﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="u280759ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="u280759ConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.u280759ConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ManagerVerificationTableAdapter" GeneratorDataComponentClassName="GET_ManagerVerificationTableAdapter" Name="GET_ManagerVerification" UserDataComponentName="GET_ManagerVerificationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_ManagerVerification" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_ManagerVerification</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ManagerName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varbinary" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="128" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ManagerID" DataSetColumn="ManagerID" />
              <Mapping SourceColumn="ManagerRole" DataSetColumn="ManagerRole" />
              <Mapping SourceColumn="IsSuccessful" DataSetColumn="IsSuccessful" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_ManagerAccountTableAdapter" GeneratorDataComponentClassName="ADD_ManagerAccountTableAdapter" Name="ADD_ManagerAccount" UserDataComponentName="ADD_ManagerAccountTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_ManagerAccount" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_ManagerAccount</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ManagerName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varbinary" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="128" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ProducersNamesTableAdapter" GeneratorDataComponentClassName="GET_ProducersNamesTableAdapter" Name="GET_ProducersNames" UserDataComponentName="GET_ProducersNamesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_ProducersNames" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_ProducersNames</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_ProducerTableAdapter" GeneratorDataComponentClassName="ADD_ProducerTableAdapter" Name="ADD_Producer" UserDataComponentName="ADD_ProducerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_Producer" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_Producer</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ProducerName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_CountryTableAdapter" GeneratorDataComponentClassName="ADD_CountryTableAdapter" Name="ADD_Country" UserDataComponentName="ADD_CountryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_Country" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_Country</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@NameCountry" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_CountriesTableAdapter" GeneratorDataComponentClassName="GET_CountriesTableAdapter" Name="GET_Countries" UserDataComponentName="GET_CountriesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Countries" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Countries</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_CategoriesTableAdapter" GeneratorDataComponentClassName="GET_CategoriesTableAdapter" Name="GET_Categories" UserDataComponentName="GET_CategoriesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Categories" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Categories</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="Descriptin" DataSetColumn="Descriptin" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_AdminVerificationTableAdapter" GeneratorDataComponentClassName="GET_AdminVerificationTableAdapter" Name="GET_AdminVerification" UserDataComponentName="GET_AdminVerificationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_AdminVerification" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_AdminVerification</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varbinary" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="128" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Column1" DataSetColumn="Column1" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SET_ManagerPasswordTableAdapter" GeneratorDataComponentClassName="SET_ManagerPasswordTableAdapter" Name="SET_ManagerPassword" UserDataComponentName="SET_ManagerPasswordTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.SET_ManagerPassword" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SET_ManagerPassword</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ManagerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varbinary" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="128" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ManagersTableAdapter" GeneratorDataComponentClassName="GET_ManagersTableAdapter" Name="GET_Managers" UserDataComponentName="GET_ManagersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Managers" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Managers</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ManagerID" DataSetColumn="ManagerID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="Role" DataSetColumn="Role" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_ShopTableAdapter" GeneratorDataComponentClassName="ADD_ShopTableAdapter" Name="ADD_Shop" UserDataComponentName="ADD_ShopTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_Shop" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_Shop</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ShopName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ShopsTableAdapter" GeneratorDataComponentClassName="GET_ShopsTableAdapter" Name="GET_Shops" UserDataComponentName="GET_ShopsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Shops" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Shops</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_CategoryTableAdapter" GeneratorDataComponentClassName="ADD_CategoryTableAdapter" Name="ADD_Category" UserDataComponentName="ADD_CategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_Category" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_Category</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_IngredientTableAdapter" GeneratorDataComponentClassName="ADD_IngredientTableAdapter" Name="ADD_Ingredient" UserDataComponentName="ADD_IngredientTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_Ingredient" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_Ingredient</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@LightValue" Precision="3" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_IngredientsTableAdapter" GeneratorDataComponentClassName="GET_IngredientsTableAdapter" Name="GET_Ingredients" UserDataComponentName="GET_IngredientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Ingredients" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Ingredients</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IngredientID" DataSetColumn="IngredientID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_IngredientTypeTableAdapter" GeneratorDataComponentClassName="ADD_IngredientTypeTableAdapter" Name="ADD_IngredientType" UserDataComponentName="ADD_IngredientTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_IngredientType" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_IngredientType</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_IngredientTypesTableAdapter" GeneratorDataComponentClassName="GET_IngredientTypesTableAdapter" Name="GET_IngredientTypes" UserDataComponentName="GET_IngredientTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_IngredientTypes" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_IngredientTypes</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IngredientTypeID" DataSetColumn="IngredientTypeID" />
              <Mapping SourceColumn="IngredientType" DataSetColumn="IngredientType" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WaresTableAdapter" GeneratorDataComponentClassName="GET_WaresTableAdapter" Name="GET_Wares" UserDataComponentName="GET_WaresTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Wares" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Wares</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WaresID" DataSetColumn="WaresID" />
              <Mapping SourceColumn="WareName" DataSetColumn="WareName" />
              <Mapping SourceColumn="ShortDesc" DataSetColumn="ShortDesc" />
              <Mapping SourceColumn="FullDesc" DataSetColumn="FullDesc" />
              <Mapping SourceColumn="SHCode" DataSetColumn="SHCode" />
              <Mapping SourceColumn="PriceMain" DataSetColumn="PriceMain" />
              <Mapping SourceColumn="PriceRed" DataSetColumn="PriceRed" />
              <Mapping SourceColumn="GroupID" DataSetColumn="GroupID" />
              <Mapping SourceColumn="NettoWeight" DataSetColumn="NettoWeight" />
              <Mapping SourceColumn="BruttoWeight" DataSetColumn="BruttoWeight" />
              <Mapping SourceColumn="Recipe" DataSetColumn="Recipe" />
              <Mapping SourceColumn="PriceCategory" DataSetColumn="PriceCategory" />
              <Mapping SourceColumn="Staff" DataSetColumn="Staff" />
              <Mapping SourceColumn="StaffListGuid" DataSetColumn="StaffListGuid" />
              <Mapping SourceColumn="ValidBefore" DataSetColumn="ValidBefore" />
              <Mapping SourceColumn="Conditions" DataSetColumn="Conditions" />
              <Mapping SourceColumn="Protein" DataSetColumn="Protein" />
              <Mapping SourceColumn="Fat" DataSetColumn="Fat" />
              <Mapping SourceColumn="Carbonhydrates" DataSetColumn="Carbonhydrates" />
              <Mapping SourceColumn="EnergyValue" DataSetColumn="EnergyValue" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="WareCategory" DataSetColumn="WareCategory" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="DateUpdatePrice" DataSetColumn="DateUpdatePrice" />
              <Mapping SourceColumn="Counter" DataSetColumn="Counter" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="LiveID" DataSetColumn="LiveID" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="IsHidden" DataSetColumn="IsHidden" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Hide_WareTableAdapter" GeneratorDataComponentClassName="Hide_WareTableAdapter" Name="Hide_Ware" UserDataComponentName="Hide_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.Hide_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Hide_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnDelete_WareTableAdapter" GeneratorDataComponentClassName="UnDelete_WareTableAdapter" Name="UnDelete_Ware" UserDataComponentName="UnDelete_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.UnDelete_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.UnDelete_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Delete_WareTableAdapter" GeneratorDataComponentClassName="Delete_WareTableAdapter" Name="Delete_Ware" UserDataComponentName="Delete_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.Delete_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.Delete_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UnHide_WareTableAdapter" GeneratorDataComponentClassName="UnHide_WareTableAdapter" Name="UnHide_Ware" UserDataComponentName="UnHide_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.UnHide_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.UnHide_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WareTableAdapter" GeneratorDataComponentClassName="GET_WareTableAdapter" Name="GET_Ware" UserDataComponentName="GET_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WaresID" DataSetColumn="WaresID" />
              <Mapping SourceColumn="WareName" DataSetColumn="WareName" />
              <Mapping SourceColumn="ShortDesc" DataSetColumn="ShortDesc" />
              <Mapping SourceColumn="FullDesc" DataSetColumn="FullDesc" />
              <Mapping SourceColumn="SHCode" DataSetColumn="SHCode" />
              <Mapping SourceColumn="PriceMain" DataSetColumn="PriceMain" />
              <Mapping SourceColumn="PriceRed" DataSetColumn="PriceRed" />
              <Mapping SourceColumn="GroupID" DataSetColumn="GroupID" />
              <Mapping SourceColumn="NettoWeight" DataSetColumn="NettoWeight" />
              <Mapping SourceColumn="BruttoWeight" DataSetColumn="BruttoWeight" />
              <Mapping SourceColumn="Recipe" DataSetColumn="Recipe" />
              <Mapping SourceColumn="PriceCategory" DataSetColumn="PriceCategory" />
              <Mapping SourceColumn="Staff" DataSetColumn="Staff" />
              <Mapping SourceColumn="StaffListGuid" DataSetColumn="StaffListGuid" />
              <Mapping SourceColumn="ValidBefore" DataSetColumn="ValidBefore" />
              <Mapping SourceColumn="Conditions" DataSetColumn="Conditions" />
              <Mapping SourceColumn="Protein" DataSetColumn="Protein" />
              <Mapping SourceColumn="Fat" DataSetColumn="Fat" />
              <Mapping SourceColumn="Carbonhydrates" DataSetColumn="Carbonhydrates" />
              <Mapping SourceColumn="EnergyValue" DataSetColumn="EnergyValue" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="WareCategory" DataSetColumn="WareCategory" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="DateUpdatePrice" DataSetColumn="DateUpdatePrice" />
              <Mapping SourceColumn="Counter" DataSetColumn="Counter" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="LiveID" DataSetColumn="LiveID" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="IsHidden" DataSetColumn="IsHidden" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UPDATE_WareTableAdapter" GeneratorDataComponentClassName="UPDATE_WareTableAdapter" Name="UPDATE_Ware" UserDataComponentName="UPDATE_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.UPDATE_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.UPDATE_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@WareName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ShortDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@FullDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@SHCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@PriceMain" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@PriceRed" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@GroupID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@NettoWeight" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@BruttoWeight" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Recipe" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@PriceCategory" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Staff" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@StaffListGuid" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ValidBefore" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Conditions" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Protein" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Fat" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Carbonhydrates" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@EnergyValue" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Producer" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@WareCategory" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@LightValue" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@DateUpdatePrice" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Counter" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Rating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ShopID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Shop" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@LiveID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Article" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsPiece" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsHidden" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsDeleted" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WareBySHCodeTableAdapter" GeneratorDataComponentClassName="GET_WareBySHCodeTableAdapter" Name="GET_WareBySHCode" UserDataComponentName="GET_WareBySHCodeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_WareBySHCode" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_WareBySHCode</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@SHCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WaresID" DataSetColumn="WaresID" />
              <Mapping SourceColumn="WareName" DataSetColumn="WareName" />
              <Mapping SourceColumn="ShortDesc" DataSetColumn="ShortDesc" />
              <Mapping SourceColumn="FullDesc" DataSetColumn="FullDesc" />
              <Mapping SourceColumn="SHCode" DataSetColumn="SHCode" />
              <Mapping SourceColumn="PriceMain" DataSetColumn="PriceMain" />
              <Mapping SourceColumn="PriceRed" DataSetColumn="PriceRed" />
              <Mapping SourceColumn="GroupID" DataSetColumn="GroupID" />
              <Mapping SourceColumn="NettoWeight" DataSetColumn="NettoWeight" />
              <Mapping SourceColumn="BruttoWeight" DataSetColumn="BruttoWeight" />
              <Mapping SourceColumn="Recipe" DataSetColumn="Recipe" />
              <Mapping SourceColumn="PriceCategory" DataSetColumn="PriceCategory" />
              <Mapping SourceColumn="Staff" DataSetColumn="Staff" />
              <Mapping SourceColumn="StaffListGuid" DataSetColumn="StaffListGuid" />
              <Mapping SourceColumn="ValidBefore" DataSetColumn="ValidBefore" />
              <Mapping SourceColumn="Conditions" DataSetColumn="Conditions" />
              <Mapping SourceColumn="Protein" DataSetColumn="Protein" />
              <Mapping SourceColumn="Fat" DataSetColumn="Fat" />
              <Mapping SourceColumn="Carbonhydrates" DataSetColumn="Carbonhydrates" />
              <Mapping SourceColumn="EnergyValue" DataSetColumn="EnergyValue" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="WareCategory" DataSetColumn="WareCategory" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="DateUpdatePrice" DataSetColumn="DateUpdatePrice" />
              <Mapping SourceColumn="Counter" DataSetColumn="Counter" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="LiveID" DataSetColumn="LiveID" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="IsHidden" DataSetColumn="IsHidden" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_WareActionTableAdapter" GeneratorDataComponentClassName="ADD_WareActionTableAdapter" Name="ADD_WareAction" UserDataComponentName="ADD_WareActionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_WareAction" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_WareAction</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ManagerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_WareForChangesTableAdapter" GeneratorDataComponentClassName="ADD_WareForChangesTableAdapter" Name="ADD_WareForChanges" UserDataComponentName="ADD_WareForChangesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_WareForChanges" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_WareForChanges</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Shop" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="REMOVE_WaresForChangesTableAdapter" GeneratorDataComponentClassName="REMOVE_WaresForChangesTableAdapter" Name="REMOVE_WaresForChanges" UserDataComponentName="REMOVE_WaresForChangesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.REMOVE_WaresForChanges" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.REMOVE_WaresForChanges</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WareActionsTableAdapter" GeneratorDataComponentClassName="GET_WareActionsTableAdapter" Name="GET_WareActions" UserDataComponentName="GET_WareActionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_WareActions" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_WareActions</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActionID" DataSetColumn="ActionID" />
              <Mapping SourceColumn="WareID" DataSetColumn="WareID" />
              <Mapping SourceColumn="ManagerID" DataSetColumn="ManagerID" />
              <Mapping SourceColumn="UpdateTime" DataSetColumn="UpdateTime" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WareActionsByManagerTableAdapter" GeneratorDataComponentClassName="GET_WareActionsByManagerTableAdapter" Name="GET_WareActionsByManager" UserDataComponentName="GET_WareActionsByManagerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_WareActionsByManager" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_WareActionsByManager</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ManagerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActionID" DataSetColumn="ActionID" />
              <Mapping SourceColumn="WareID" DataSetColumn="WareID" />
              <Mapping SourceColumn="ManagerID" DataSetColumn="ManagerID" />
              <Mapping SourceColumn="UpdateTime" DataSetColumn="UpdateTime" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_AllWareActionsTableAdapter" GeneratorDataComponentClassName="GET_AllWareActionsTableAdapter" Name="GET_AllWareActions" UserDataComponentName="GET_AllWareActionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_AllWareActions" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_AllWareActions</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActionID" DataSetColumn="ActionID" />
              <Mapping SourceColumn="WareID" DataSetColumn="WareID" />
              <Mapping SourceColumn="ManagerID" DataSetColumn="ManagerID" />
              <Mapping SourceColumn="UpdateTime" DataSetColumn="UpdateTime" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ClientVerificationTableAdapter" GeneratorDataComponentClassName="GET_ClientVerificationTableAdapter" Name="GET_ClientVerification" UserDataComponentName="GET_ClientVerificationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_ClientVerification" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_ClientVerification</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varbinary" DbType="Binary" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarBinary" Scale="0" Size="128" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="IsSuccessful" DataSetColumn="IsSuccessful" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_IsFavoriteWareTableAdapter" GeneratorDataComponentClassName="GET_IsFavoriteWareTableAdapter" Name="GET_IsFavoriteWare" UserDataComponentName="GET_IsFavoriteWareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_IsFavoriteWare" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_IsFavoriteWare</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IsFavorite" DataSetColumn="IsFavorite" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_IsMarkedWareTableAdapter" GeneratorDataComponentClassName="GET_IsMarkedWareTableAdapter" Name="GET_IsMarkedWare" UserDataComponentName="GET_IsMarkedWareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_IsMarkedWare" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_IsMarkedWare</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IsMarked" DataSetColumn="IsMarked" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_FavoriteWareTableAdapter" GeneratorDataComponentClassName="ADD_FavoriteWareTableAdapter" Name="ADD_FavoriteWare" UserDataComponentName="ADD_FavoriteWareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_FavoriteWare" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_FavoriteWare</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_StaffListTableAdapter" GeneratorDataComponentClassName="GET_StaffListTableAdapter" Name="GET_StaffList" UserDataComponentName="GET_StaffListTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_StaffList" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_StaffList</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@StaffGuidList" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IngridientID" DataSetColumn="IngridientID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_CheckListTableAdapter" GeneratorDataComponentClassName="GET_CheckListTableAdapter" Name="GET_CheckList" UserDataComponentName="GET_CheckListTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_CheckList" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_CheckList</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@CheckListID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CheckID" DataSetColumn="CheckID" />
              <Mapping SourceColumn="CheckListID" DataSetColumn="CheckListID" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="WareID" DataSetColumn="WareID" />
              <Mapping SourceColumn="Count" DataSetColumn="Count" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="Weigh" DataSetColumn="Weigh" />
              <Mapping SourceColumn="IsChecked" DataSetColumn="IsChecked" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ClientCheckListsTableAdapter" GeneratorDataComponentClassName="GET_ClientCheckListsTableAdapter" Name="GET_ClientCheckLists" UserDataComponentName="GET_ClientCheckListsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_ClientCheckLists" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_ClientCheckLists</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ClientID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CheckListID" DataSetColumn="CheckListID" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WareAnalogsTableAdapter" GeneratorDataComponentClassName="GET_WareAnalogsTableAdapter" Name="GET_WareAnalogs" UserDataComponentName="GET_WareAnalogsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_WareAnalogs" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_WareAnalogs</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@LiveID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@GroupID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Shop" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WaresID" DataSetColumn="WaresID" />
              <Mapping SourceColumn="WareName" DataSetColumn="WareName" />
              <Mapping SourceColumn="ShortDesc" DataSetColumn="ShortDesc" />
              <Mapping SourceColumn="FullDesc" DataSetColumn="FullDesc" />
              <Mapping SourceColumn="SHCode" DataSetColumn="SHCode" />
              <Mapping SourceColumn="PriceMain" DataSetColumn="PriceMain" />
              <Mapping SourceColumn="PriceRed" DataSetColumn="PriceRed" />
              <Mapping SourceColumn="GroupID" DataSetColumn="GroupID" />
              <Mapping SourceColumn="NettoWeight" DataSetColumn="NettoWeight" />
              <Mapping SourceColumn="BruttoWeight" DataSetColumn="BruttoWeight" />
              <Mapping SourceColumn="Recipe" DataSetColumn="Recipe" />
              <Mapping SourceColumn="PriceCategory" DataSetColumn="PriceCategory" />
              <Mapping SourceColumn="Staff" DataSetColumn="Staff" />
              <Mapping SourceColumn="StaffListGuid" DataSetColumn="StaffListGuid" />
              <Mapping SourceColumn="ValidBefore" DataSetColumn="ValidBefore" />
              <Mapping SourceColumn="Conditions" DataSetColumn="Conditions" />
              <Mapping SourceColumn="Protein" DataSetColumn="Protein" />
              <Mapping SourceColumn="Fat" DataSetColumn="Fat" />
              <Mapping SourceColumn="Carbonhydrates" DataSetColumn="Carbonhydrates" />
              <Mapping SourceColumn="EnergyValue" DataSetColumn="EnergyValue" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="WareCategory" DataSetColumn="WareCategory" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="DateUpdatePrice" DataSetColumn="DateUpdatePrice" />
              <Mapping SourceColumn="Counter" DataSetColumn="Counter" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="LiveID" DataSetColumn="LiveID" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="IsHidden" DataSetColumn="IsHidden" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SET_WarePriceTableAdapter" GeneratorDataComponentClassName="SET_WarePriceTableAdapter" Name="SET_WarePrice" UserDataComponentName="SET_WarePriceTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.SET_WarePrice" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SET_WarePrice</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@PriceMain" Precision="5" ProviderType="Decimal" Scale="2" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@PriceRed" Precision="5" ProviderType="Decimal" Scale="2" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WaresForChangesTableAdapter" GeneratorDataComponentClassName="GET_WaresForChangesTableAdapter" Name="GET_WaresForChanges" UserDataComponentName="GET_WaresForChangesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_WaresForChanges" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_WaresForChanges</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Shop" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MarkID" DataSetColumn="MarkID" />
              <Mapping SourceColumn="WareID" DataSetColumn="WareID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="ClientID" DataSetColumn="ClientID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_CategoryImportTableAdapter" GeneratorDataComponentClassName="ADD_CategoryImportTableAdapter" Name="ADD_CategoryImport" UserDataComponentName="ADD_CategoryImportTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_CategoryImport" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_CategoryImport</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@LocalID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ParentID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_ImportCategoryTableAdapter" GeneratorDataComponentClassName="GET_ImportCategoryTableAdapter" Name="GET_ImportCategory" UserDataComponentName="GET_ImportCategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_ImportCategory" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_ImportCategory</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@LocalID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_CategoryTableAdapter" GeneratorDataComponentClassName="GET_CategoryTableAdapter" Name="GET_Category" UserDataComponentName="GET_CategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_Category" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_Category</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="Descriptin" DataSetColumn="Descriptin" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_CategoryByNameTableAdapter" GeneratorDataComponentClassName="GET_CategoryByNameTableAdapter" Name="GET_CategoryByName" UserDataComponentName="GET_CategoryByNameTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_CategoryByName" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_CategoryByName</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ParentID" DataSetColumn="ParentID" />
              <Mapping SourceColumn="Descriptin" DataSetColumn="Descriptin" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FIND_WareAnalogsTableAdapter" GeneratorDataComponentClassName="FIND_WareAnalogsTableAdapter" Name="FIND_WareAnalogs" UserDataComponentName="FIND_WareAnalogsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.FIND_WareAnalogs" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.FIND_WareAnalogs</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@WareCategory" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Weight" Precision="6" ProviderType="Decimal" Scale="0" Size="5" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WaresID" DataSetColumn="WaresID" />
              <Mapping SourceColumn="WareName" DataSetColumn="WareName" />
              <Mapping SourceColumn="ShortDesc" DataSetColumn="ShortDesc" />
              <Mapping SourceColumn="FullDesc" DataSetColumn="FullDesc" />
              <Mapping SourceColumn="SHCode" DataSetColumn="SHCode" />
              <Mapping SourceColumn="PriceMain" DataSetColumn="PriceMain" />
              <Mapping SourceColumn="PriceRed" DataSetColumn="PriceRed" />
              <Mapping SourceColumn="GroupID" DataSetColumn="GroupID" />
              <Mapping SourceColumn="NettoWeight" DataSetColumn="NettoWeight" />
              <Mapping SourceColumn="BruttoWeight" DataSetColumn="BruttoWeight" />
              <Mapping SourceColumn="Recipe" DataSetColumn="Recipe" />
              <Mapping SourceColumn="PriceCategory" DataSetColumn="PriceCategory" />
              <Mapping SourceColumn="Staff" DataSetColumn="Staff" />
              <Mapping SourceColumn="StaffListGuid" DataSetColumn="StaffListGuid" />
              <Mapping SourceColumn="ValidBefore" DataSetColumn="ValidBefore" />
              <Mapping SourceColumn="Conditions" DataSetColumn="Conditions" />
              <Mapping SourceColumn="Protein" DataSetColumn="Protein" />
              <Mapping SourceColumn="Fat" DataSetColumn="Fat" />
              <Mapping SourceColumn="Carbonhydrates" DataSetColumn="Carbonhydrates" />
              <Mapping SourceColumn="EnergyValue" DataSetColumn="EnergyValue" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="WareCategory" DataSetColumn="WareCategory" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="DateUpdatePrice" DataSetColumn="DateUpdatePrice" />
              <Mapping SourceColumn="Counter" DataSetColumn="Counter" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="LiveID" DataSetColumn="LiveID" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="IsHidden" DataSetColumn="IsHidden" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SET_GroupIDTableAdapter" GeneratorDataComponentClassName="SET_GroupIDTableAdapter" Name="SET_GroupID" UserDataComponentName="SET_GroupIDTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.SET_GroupID" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.SET_GroupID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@GroupID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ADD_WareTableAdapter" GeneratorDataComponentClassName="ADD_WareTableAdapter" Name="ADD_Ware" UserDataComponentName="ADD_WareTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.ADD_Ware" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.ADD_Ware</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@WareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@WareName" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ShortDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@FullDesc" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@SHCode" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@PriceMain" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@PriceRed" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@GroupID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@NettoWeight" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@BruttoWeight" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Recipe" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@PriceCategory" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Staff" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@StaffListGuid" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ValidBefore" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Conditions" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Protein" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Fat" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@Carbonhydrates" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@EnergyValue" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Producer" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Country" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@WareCategory" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="decimal" DbType="Decimal" Direction="Input" ParameterName="@LightValue" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@DateUpdatePrice" Precision="0" ProviderType="VarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Counter" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Rating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ShopID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Shop" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@LiveID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Article" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsPiece" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsHidden" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@IsDeleted" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings />
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GET_WaresWithFiltersTableAdapter" GeneratorDataComponentClassName="GET_WaresWithFiltersTableAdapter" Name="GET_WaresWithFilters" UserDataComponentName="GET_WaresWithFiltersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="u280759ConnectionString (Web.config)" DbObjectName="u280759.dbo.GET_WaresWithFilters" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.GET_WaresWithFilters</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Category" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@ShopID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WaresID" DataSetColumn="WaresID" />
              <Mapping SourceColumn="WareName" DataSetColumn="WareName" />
              <Mapping SourceColumn="ShortDesc" DataSetColumn="ShortDesc" />
              <Mapping SourceColumn="FullDesc" DataSetColumn="FullDesc" />
              <Mapping SourceColumn="SHCode" DataSetColumn="SHCode" />
              <Mapping SourceColumn="PriceMain" DataSetColumn="PriceMain" />
              <Mapping SourceColumn="PriceRed" DataSetColumn="PriceRed" />
              <Mapping SourceColumn="GroupID" DataSetColumn="GroupID" />
              <Mapping SourceColumn="NettoWeight" DataSetColumn="NettoWeight" />
              <Mapping SourceColumn="BruttoWeight" DataSetColumn="BruttoWeight" />
              <Mapping SourceColumn="Recipe" DataSetColumn="Recipe" />
              <Mapping SourceColumn="PriceCategory" DataSetColumn="PriceCategory" />
              <Mapping SourceColumn="Staff" DataSetColumn="Staff" />
              <Mapping SourceColumn="StaffListGuid" DataSetColumn="StaffListGuid" />
              <Mapping SourceColumn="ValidBefore" DataSetColumn="ValidBefore" />
              <Mapping SourceColumn="Conditions" DataSetColumn="Conditions" />
              <Mapping SourceColumn="Protein" DataSetColumn="Protein" />
              <Mapping SourceColumn="Fat" DataSetColumn="Fat" />
              <Mapping SourceColumn="Carbonhydrates" DataSetColumn="Carbonhydrates" />
              <Mapping SourceColumn="EnergyValue" DataSetColumn="EnergyValue" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="WareCategory" DataSetColumn="WareCategory" />
              <Mapping SourceColumn="LightValue" DataSetColumn="LightValue" />
              <Mapping SourceColumn="DateUpdatePrice" DataSetColumn="DateUpdatePrice" />
              <Mapping SourceColumn="Counter" DataSetColumn="Counter" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="ShopID" DataSetColumn="ShopID" />
              <Mapping SourceColumn="Shop" DataSetColumn="Shop" />
              <Mapping SourceColumn="LiveID" DataSetColumn="LiveID" />
              <Mapping SourceColumn="Article" DataSetColumn="Article" />
              <Mapping SourceColumn="IsPiece" DataSetColumn="IsPiece" />
              <Mapping SourceColumn="IsHidden" DataSetColumn="IsHidden" />
              <Mapping SourceColumn="IsDeleted" DataSetColumn="IsDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="GET_ManagerVerification" msprop:Generator_TableClassName="GET_ManagerVerificationDataTable" msprop:Generator_TableVarName="tableGET_ManagerVerification" msprop:Generator_TablePropName="GET_ManagerVerification" msprop:Generator_RowDeletingName="GET_ManagerVerificationRowDeleting" msprop:Generator_UserTableName="GET_ManagerVerification" msprop:Generator_RowChangingName="GET_ManagerVerificationRowChanging" msprop:Generator_RowEvHandlerName="GET_ManagerVerificationRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ManagerVerificationRowDeleted" msprop:Generator_RowEvArgName="GET_ManagerVerificationRowChangeEvent" msprop:Generator_RowChangedName="GET_ManagerVerificationRowChanged" msprop:Generator_RowClassName="GET_ManagerVerificationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ManagerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnManagerID" msprop:Generator_ColumnPropNameInRow="ManagerID" msprop:Generator_ColumnPropNameInTable="ManagerIDColumn" msprop:Generator_UserColumnName="ManagerID" type="xs:string" minOccurs="0" />
              <xs:element name="ManagerRole" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnManagerRole" msprop:Generator_ColumnPropNameInRow="ManagerRole" msprop:Generator_ColumnPropNameInTable="ManagerRoleColumn" msprop:Generator_UserColumnName="ManagerRole" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsSuccessful" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnIsSuccessful" msprop:Generator_ColumnPropNameInRow="IsSuccessful" msprop:Generator_ColumnPropNameInTable="IsSuccessfulColumn" msprop:Generator_UserColumnName="IsSuccessful" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_ManagerAccount" msprop:Generator_TableClassName="ADD_ManagerAccountDataTable" msprop:Generator_TableVarName="tableADD_ManagerAccount" msprop:Generator_TablePropName="ADD_ManagerAccount" msprop:Generator_RowDeletingName="ADD_ManagerAccountRowDeleting" msprop:Generator_UserTableName="ADD_ManagerAccount" msprop:Generator_RowChangingName="ADD_ManagerAccountRowChanging" msprop:Generator_RowEvHandlerName="ADD_ManagerAccountRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_ManagerAccountRowDeleted" msprop:Generator_RowEvArgName="ADD_ManagerAccountRowChangeEvent" msprop:Generator_RowChangedName="ADD_ManagerAccountRowChanged" msprop:Generator_RowClassName="ADD_ManagerAccountRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_ProducersNames" msprop:Generator_TableClassName="GET_ProducersNamesDataTable" msprop:Generator_TableVarName="tableGET_ProducersNames" msprop:Generator_TablePropName="GET_ProducersNames" msprop:Generator_RowDeletingName="GET_ProducersNamesRowDeleting" msprop:Generator_UserTableName="GET_ProducersNames" msprop:Generator_RowChangingName="GET_ProducersNamesRowChanging" msprop:Generator_RowEvHandlerName="GET_ProducersNamesRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ProducersNamesRowDeleted" msprop:Generator_RowEvArgName="GET_ProducersNamesRowChangeEvent" msprop:Generator_RowChangedName="GET_ProducersNamesRowChanged" msprop:Generator_RowClassName="GET_ProducersNamesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_Producer" msprop:Generator_TableClassName="ADD_ProducerDataTable" msprop:Generator_TableVarName="tableADD_Producer" msprop:Generator_TablePropName="ADD_Producer" msprop:Generator_RowDeletingName="ADD_ProducerRowDeleting" msprop:Generator_UserTableName="ADD_Producer" msprop:Generator_RowChangingName="ADD_ProducerRowChanging" msprop:Generator_RowEvHandlerName="ADD_ProducerRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_ProducerRowDeleted" msprop:Generator_RowEvArgName="ADD_ProducerRowChangeEvent" msprop:Generator_RowChangedName="ADD_ProducerRowChanged" msprop:Generator_RowClassName="ADD_ProducerRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_Country" msprop:Generator_TableClassName="ADD_CountryDataTable" msprop:Generator_TableVarName="tableADD_Country" msprop:Generator_TablePropName="ADD_Country" msprop:Generator_RowDeletingName="ADD_CountryRowDeleting" msprop:Generator_UserTableName="ADD_Country" msprop:Generator_RowChangingName="ADD_CountryRowChanging" msprop:Generator_RowEvHandlerName="ADD_CountryRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_CountryRowDeleted" msprop:Generator_RowEvArgName="ADD_CountryRowChangeEvent" msprop:Generator_RowChangedName="ADD_CountryRowChanged" msprop:Generator_RowClassName="ADD_CountryRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Countries" msprop:Generator_TableClassName="GET_CountriesDataTable" msprop:Generator_TableVarName="tableGET_Countries" msprop:Generator_TablePropName="GET_Countries" msprop:Generator_RowDeletingName="GET_CountriesRowDeleting" msprop:Generator_UserTableName="GET_Countries" msprop:Generator_RowChangingName="GET_CountriesRowChanging" msprop:Generator_RowEvHandlerName="GET_CountriesRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_CountriesRowDeleted" msprop:Generator_RowEvArgName="GET_CountriesRowChangeEvent" msprop:Generator_RowChangedName="GET_CountriesRowChanged" msprop:Generator_RowClassName="GET_CountriesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Categories" msprop:Generator_TableClassName="GET_CategoriesDataTable" msprop:Generator_TableVarName="tableGET_Categories" msprop:Generator_TablePropName="GET_Categories" msprop:Generator_RowDeletingName="GET_CategoriesRowDeleting" msprop:Generator_UserTableName="GET_Categories" msprop:Generator_RowChangingName="GET_CategoriesRowChanging" msprop:Generator_RowEvHandlerName="GET_CategoriesRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_CategoriesRowDeleted" msprop:Generator_RowEvArgName="GET_CategoriesRowChangeEvent" msprop:Generator_RowChangedName="GET_CategoriesRowChanged" msprop:Generator_RowClassName="GET_CategoriesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ParentID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" msprop:Generator_UserColumnName="ParentID" type="xs:string" minOccurs="0" />
              <xs:element name="Descriptin" msprop:Generator_ColumnVarNameInTable="columnDescriptin" msprop:Generator_ColumnPropNameInRow="Descriptin" msprop:Generator_ColumnPropNameInTable="DescriptinColumn" msprop:Generator_UserColumnName="Descriptin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_AdminVerification" msprop:Generator_TableClassName="GET_AdminVerificationDataTable" msprop:Generator_TableVarName="tableGET_AdminVerification" msprop:Generator_TablePropName="GET_AdminVerification" msprop:Generator_RowDeletingName="GET_AdminVerificationRowDeleting" msprop:Generator_UserTableName="GET_AdminVerification" msprop:Generator_RowChangingName="GET_AdminVerificationRowChanging" msprop:Generator_RowEvHandlerName="GET_AdminVerificationRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_AdminVerificationRowDeleted" msprop:Generator_RowEvArgName="GET_AdminVerificationRowChangeEvent" msprop:Generator_RowChangedName="GET_AdminVerificationRowChanged" msprop:Generator_RowClassName="GET_AdminVerificationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Column1" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnColumn1" msprop:Generator_ColumnPropNameInRow="Column1" msprop:Generator_ColumnPropNameInTable="Column1Column" msprop:Generator_UserColumnName="Column1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SET_ManagerPassword" msprop:Generator_TableClassName="SET_ManagerPasswordDataTable" msprop:Generator_TableVarName="tableSET_ManagerPassword" msprop:Generator_TablePropName="SET_ManagerPassword" msprop:Generator_RowDeletingName="SET_ManagerPasswordRowDeleting" msprop:Generator_UserTableName="SET_ManagerPassword" msprop:Generator_RowChangingName="SET_ManagerPasswordRowChanging" msprop:Generator_RowEvHandlerName="SET_ManagerPasswordRowChangeEventHandler" msprop:Generator_RowDeletedName="SET_ManagerPasswordRowDeleted" msprop:Generator_RowEvArgName="SET_ManagerPasswordRowChangeEvent" msprop:Generator_RowChangedName="SET_ManagerPasswordRowChanged" msprop:Generator_RowClassName="SET_ManagerPasswordRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Managers" msprop:Generator_TableClassName="GET_ManagersDataTable" msprop:Generator_TableVarName="tableGET_Managers" msprop:Generator_TablePropName="GET_Managers" msprop:Generator_RowDeletingName="GET_ManagersRowDeleting" msprop:Generator_UserTableName="GET_Managers" msprop:Generator_RowChangingName="GET_ManagersRowChanging" msprop:Generator_RowEvHandlerName="GET_ManagersRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ManagersRowDeleted" msprop:Generator_RowEvArgName="GET_ManagersRowChangeEvent" msprop:Generator_RowChangedName="GET_ManagersRowChanged" msprop:Generator_RowClassName="GET_ManagersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ManagerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnManagerID" msprop:Generator_ColumnPropNameInRow="ManagerID" msprop:Generator_ColumnPropNameInTable="ManagerIDColumn" msprop:Generator_UserColumnName="ManagerID" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnPropNameInTable="PasswordColumn" msprop:Generator_UserColumnName="Password" type="xs:base64Binary" />
              <xs:element name="Role" msprop:Generator_ColumnVarNameInTable="columnRole" msprop:Generator_ColumnPropNameInRow="Role" msprop:Generator_ColumnPropNameInTable="RoleColumn" msprop:Generator_UserColumnName="Role">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_Shop" msprop:Generator_TableClassName="ADD_ShopDataTable" msprop:Generator_TableVarName="tableADD_Shop" msprop:Generator_TablePropName="ADD_Shop" msprop:Generator_RowDeletingName="ADD_ShopRowDeleting" msprop:Generator_UserTableName="ADD_Shop" msprop:Generator_RowChangingName="ADD_ShopRowChanging" msprop:Generator_RowEvHandlerName="ADD_ShopRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_ShopRowDeleted" msprop:Generator_RowEvArgName="ADD_ShopRowChangeEvent" msprop:Generator_RowChangedName="ADD_ShopRowChanged" msprop:Generator_RowClassName="ADD_ShopRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Shops" msprop:Generator_TableClassName="GET_ShopsDataTable" msprop:Generator_TableVarName="tableGET_Shops" msprop:Generator_TablePropName="GET_Shops" msprop:Generator_RowDeletingName="GET_ShopsRowDeleting" msprop:Generator_UserTableName="GET_Shops" msprop:Generator_RowChangingName="GET_ShopsRowChanging" msprop:Generator_RowEvHandlerName="GET_ShopsRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ShopsRowDeleted" msprop:Generator_RowEvArgName="GET_ShopsRowChangeEvent" msprop:Generator_RowChangedName="GET_ShopsRowChanged" msprop:Generator_RowClassName="GET_ShopsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_Category" msprop:Generator_TableClassName="ADD_CategoryDataTable" msprop:Generator_TableVarName="tableADD_Category" msprop:Generator_TablePropName="ADD_Category" msprop:Generator_RowDeletingName="ADD_CategoryRowDeleting" msprop:Generator_UserTableName="ADD_Category" msprop:Generator_RowChangingName="ADD_CategoryRowChanging" msprop:Generator_RowEvHandlerName="ADD_CategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_CategoryRowDeleted" msprop:Generator_RowEvArgName="ADD_CategoryRowChangeEvent" msprop:Generator_RowChangedName="ADD_CategoryRowChanged" msprop:Generator_RowClassName="ADD_CategoryRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_Ingredient" msprop:Generator_TableClassName="ADD_IngredientDataTable" msprop:Generator_TableVarName="tableADD_Ingredient" msprop:Generator_TablePropName="ADD_Ingredient" msprop:Generator_RowDeletingName="ADD_IngredientRowDeleting" msprop:Generator_UserTableName="ADD_Ingredient" msprop:Generator_RowChangingName="ADD_IngredientRowChanging" msprop:Generator_RowEvHandlerName="ADD_IngredientRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_IngredientRowDeleted" msprop:Generator_RowEvArgName="ADD_IngredientRowChangeEvent" msprop:Generator_RowChangedName="ADD_IngredientRowChanged" msprop:Generator_RowClassName="ADD_IngredientRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Ingredients" msprop:Generator_TableClassName="GET_IngredientsDataTable" msprop:Generator_TableVarName="tableGET_Ingredients" msprop:Generator_TablePropName="GET_Ingredients" msprop:Generator_RowDeletingName="GET_IngredientsRowDeleting" msprop:Generator_UserTableName="GET_Ingredients" msprop:Generator_RowChangingName="GET_IngredientsRowChanging" msprop:Generator_RowEvHandlerName="GET_IngredientsRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_IngredientsRowDeleted" msprop:Generator_RowEvArgName="GET_IngredientsRowChangeEvent" msprop:Generator_RowChangedName="GET_IngredientsRowChanged" msprop:Generator_RowClassName="GET_IngredientsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IngredientID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnIngredientID" msprop:Generator_ColumnPropNameInRow="IngredientID" msprop:Generator_ColumnPropNameInTable="IngredientIDColumn" msprop:Generator_UserColumnName="IngredientID" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" />
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_IngredientType" msprop:Generator_TableClassName="ADD_IngredientTypeDataTable" msprop:Generator_TableVarName="tableADD_IngredientType" msprop:Generator_TablePropName="ADD_IngredientType" msprop:Generator_RowDeletingName="ADD_IngredientTypeRowDeleting" msprop:Generator_UserTableName="ADD_IngredientType" msprop:Generator_RowChangingName="ADD_IngredientTypeRowChanging" msprop:Generator_RowEvHandlerName="ADD_IngredientTypeRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_IngredientTypeRowDeleted" msprop:Generator_RowEvArgName="ADD_IngredientTypeRowChangeEvent" msprop:Generator_RowChangedName="ADD_IngredientTypeRowChanged" msprop:Generator_RowClassName="ADD_IngredientTypeRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_IngredientTypes" msprop:Generator_TableClassName="GET_IngredientTypesDataTable" msprop:Generator_TableVarName="tableGET_IngredientTypes" msprop:Generator_TablePropName="GET_IngredientTypes" msprop:Generator_RowDeletingName="GET_IngredientTypesRowDeleting" msprop:Generator_UserTableName="GET_IngredientTypes" msprop:Generator_RowChangingName="GET_IngredientTypesRowChanging" msprop:Generator_RowEvHandlerName="GET_IngredientTypesRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_IngredientTypesRowDeleted" msprop:Generator_RowEvArgName="GET_IngredientTypesRowChangeEvent" msprop:Generator_RowChangedName="GET_IngredientTypesRowChanged" msprop:Generator_RowClassName="GET_IngredientTypesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IngredientTypeID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnIngredientTypeID" msprop:Generator_ColumnPropNameInRow="IngredientTypeID" msprop:Generator_ColumnPropNameInTable="IngredientTypeIDColumn" msprop:Generator_UserColumnName="IngredientTypeID" type="xs:string" />
              <xs:element name="IngredientType" msprop:Generator_ColumnVarNameInTable="columnIngredientType" msprop:Generator_ColumnPropNameInRow="IngredientType" msprop:Generator_ColumnPropNameInTable="IngredientTypeColumn" msprop:Generator_UserColumnName="IngredientType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Wares" msprop:Generator_TableClassName="GET_WaresDataTable" msprop:Generator_TableVarName="tableGET_Wares" msprop:Generator_TablePropName="GET_Wares" msprop:Generator_RowDeletingName="GET_WaresRowDeleting" msprop:Generator_UserTableName="GET_Wares" msprop:Generator_RowChangingName="GET_WaresRowChanging" msprop:Generator_RowEvHandlerName="GET_WaresRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WaresRowDeleted" msprop:Generator_RowEvArgName="GET_WaresRowChangeEvent" msprop:Generator_RowChangedName="GET_WaresRowChanged" msprop:Generator_RowClassName="GET_WaresRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WaresID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWaresID" msprop:Generator_ColumnPropNameInRow="WaresID" msprop:Generator_ColumnPropNameInTable="WaresIDColumn" msprop:Generator_UserColumnName="WaresID" type="xs:string" />
              <xs:element name="WareName" msprop:Generator_ColumnVarNameInTable="columnWareName" msprop:Generator_ColumnPropNameInRow="WareName" msprop:Generator_ColumnPropNameInTable="WareNameColumn" msprop:Generator_UserColumnName="WareName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDesc" msprop:Generator_ColumnVarNameInTable="columnShortDesc" msprop:Generator_ColumnPropNameInRow="ShortDesc" msprop:Generator_ColumnPropNameInTable="ShortDescColumn" msprop:Generator_UserColumnName="ShortDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDesc" msprop:Generator_ColumnVarNameInTable="columnFullDesc" msprop:Generator_ColumnPropNameInRow="FullDesc" msprop:Generator_ColumnPropNameInTable="FullDescColumn" msprop:Generator_UserColumnName="FullDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SHCode" msprop:Generator_ColumnVarNameInTable="columnSHCode" msprop:Generator_ColumnPropNameInRow="SHCode" msprop:Generator_ColumnPropNameInTable="SHCodeColumn" msprop:Generator_UserColumnName="SHCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceMain" msprop:Generator_ColumnVarNameInTable="columnPriceMain" msprop:Generator_ColumnPropNameInRow="PriceMain" msprop:Generator_ColumnPropNameInTable="PriceMainColumn" msprop:Generator_UserColumnName="PriceMain" type="xs:decimal" />
              <xs:element name="PriceRed" msprop:Generator_ColumnVarNameInTable="columnPriceRed" msprop:Generator_ColumnPropNameInRow="PriceRed" msprop:Generator_ColumnPropNameInTable="PriceRedColumn" msprop:Generator_UserColumnName="PriceRed" type="xs:decimal" minOccurs="0" />
              <xs:element name="GroupID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGroupID" msprop:Generator_ColumnPropNameInRow="GroupID" msprop:Generator_ColumnPropNameInTable="GroupIDColumn" msprop:Generator_UserColumnName="GroupID" type="xs:string" minOccurs="0" />
              <xs:element name="NettoWeight" msprop:Generator_ColumnVarNameInTable="columnNettoWeight" msprop:Generator_ColumnPropNameInRow="NettoWeight" msprop:Generator_ColumnPropNameInTable="NettoWeightColumn" msprop:Generator_UserColumnName="NettoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="BruttoWeight" msprop:Generator_ColumnVarNameInTable="columnBruttoWeight" msprop:Generator_ColumnPropNameInRow="BruttoWeight" msprop:Generator_ColumnPropNameInTable="BruttoWeightColumn" msprop:Generator_UserColumnName="BruttoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="Recipe" msprop:Generator_ColumnVarNameInTable="columnRecipe" msprop:Generator_ColumnPropNameInRow="Recipe" msprop:Generator_ColumnPropNameInTable="RecipeColumn" msprop:Generator_UserColumnName="Recipe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceCategory" msprop:Generator_ColumnVarNameInTable="columnPriceCategory" msprop:Generator_ColumnPropNameInRow="PriceCategory" msprop:Generator_ColumnPropNameInTable="PriceCategoryColumn" msprop:Generator_UserColumnName="PriceCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Staff" msprop:Generator_ColumnVarNameInTable="columnStaff" msprop:Generator_ColumnPropNameInRow="Staff" msprop:Generator_ColumnPropNameInTable="StaffColumn" msprop:Generator_UserColumnName="Staff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffListGuid" msprop:Generator_ColumnVarNameInTable="columnStaffListGuid" msprop:Generator_ColumnPropNameInRow="StaffListGuid" msprop:Generator_ColumnPropNameInTable="StaffListGuidColumn" msprop:Generator_UserColumnName="StaffListGuid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidBefore" msprop:Generator_ColumnVarNameInTable="columnValidBefore" msprop:Generator_ColumnPropNameInRow="ValidBefore" msprop:Generator_ColumnPropNameInTable="ValidBeforeColumn" msprop:Generator_UserColumnName="ValidBefore" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conditions" msprop:Generator_ColumnVarNameInTable="columnConditions" msprop:Generator_ColumnPropNameInRow="Conditions" msprop:Generator_ColumnPropNameInTable="ConditionsColumn" msprop:Generator_UserColumnName="Conditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Protein" msprop:Generator_ColumnVarNameInTable="columnProtein" msprop:Generator_ColumnPropNameInRow="Protein" msprop:Generator_ColumnPropNameInTable="ProteinColumn" msprop:Generator_UserColumnName="Protein" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fat" msprop:Generator_ColumnVarNameInTable="columnFat" msprop:Generator_ColumnPropNameInRow="Fat" msprop:Generator_ColumnPropNameInTable="FatColumn" msprop:Generator_UserColumnName="Fat" type="xs:decimal" minOccurs="0" />
              <xs:element name="Carbonhydrates" msprop:Generator_ColumnVarNameInTable="columnCarbonhydrates" msprop:Generator_ColumnPropNameInRow="Carbonhydrates" msprop:Generator_ColumnPropNameInTable="CarbonhydratesColumn" msprop:Generator_UserColumnName="Carbonhydrates" type="xs:decimal" minOccurs="0" />
              <xs:element name="EnergyValue" msprop:Generator_ColumnVarNameInTable="columnEnergyValue" msprop:Generator_ColumnPropNameInRow="EnergyValue" msprop:Generator_ColumnPropNameInTable="EnergyValueColumn" msprop:Generator_UserColumnName="EnergyValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareCategory" msprop:Generator_ColumnVarNameInTable="columnWareCategory" msprop:Generator_ColumnPropNameInRow="WareCategory" msprop:Generator_ColumnPropNameInTable="WareCategoryColumn" msprop:Generator_UserColumnName="WareCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="DateUpdatePrice" msprop:Generator_ColumnVarNameInTable="columnDateUpdatePrice" msprop:Generator_ColumnPropNameInRow="DateUpdatePrice" msprop:Generator_ColumnPropNameInTable="DateUpdatePriceColumn" msprop:Generator_UserColumnName="DateUpdatePrice" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Counter" msprop:Generator_ColumnVarNameInTable="columnCounter" msprop:Generator_ColumnPropNameInRow="Counter" msprop:Generator_ColumnPropNameInTable="CounterColumn" msprop:Generator_UserColumnName="Counter" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" />
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" minOccurs="0" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LiveID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLiveID" msprop:Generator_ColumnPropNameInRow="LiveID" msprop:Generator_ColumnPropNameInTable="LiveIDColumn" msprop:Generator_UserColumnName="LiveID" type="xs:string" minOccurs="0" />
              <xs:element name="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsHidden" msprop:Generator_ColumnVarNameInTable="columnIsHidden" msprop:Generator_ColumnPropNameInRow="IsHidden" msprop:Generator_ColumnPropNameInTable="IsHiddenColumn" msprop:Generator_UserColumnName="IsHidden" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Hide_Ware" msprop:Generator_TableClassName="Hide_WareDataTable" msprop:Generator_TableVarName="tableHide_Ware" msprop:Generator_TablePropName="Hide_Ware" msprop:Generator_RowDeletingName="Hide_WareRowDeleting" msprop:Generator_UserTableName="Hide_Ware" msprop:Generator_RowChangingName="Hide_WareRowChanging" msprop:Generator_RowEvHandlerName="Hide_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="Hide_WareRowDeleted" msprop:Generator_RowEvArgName="Hide_WareRowChangeEvent" msprop:Generator_RowChangedName="Hide_WareRowChanged" msprop:Generator_RowClassName="Hide_WareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="UnDelete_Ware" msprop:Generator_TableClassName="UnDelete_WareDataTable" msprop:Generator_TableVarName="tableUnDelete_Ware" msprop:Generator_TablePropName="UnDelete_Ware" msprop:Generator_RowDeletingName="UnDelete_WareRowDeleting" msprop:Generator_UserTableName="UnDelete_Ware" msprop:Generator_RowChangingName="UnDelete_WareRowChanging" msprop:Generator_RowEvHandlerName="UnDelete_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="UnDelete_WareRowDeleted" msprop:Generator_RowEvArgName="UnDelete_WareRowChangeEvent" msprop:Generator_RowChangedName="UnDelete_WareRowChanged" msprop:Generator_RowClassName="UnDelete_WareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="Delete_Ware" msprop:Generator_TableClassName="Delete_WareDataTable" msprop:Generator_TableVarName="tableDelete_Ware" msprop:Generator_TablePropName="Delete_Ware" msprop:Generator_RowDeletingName="Delete_WareRowDeleting" msprop:Generator_UserTableName="Delete_Ware" msprop:Generator_RowChangingName="Delete_WareRowChanging" msprop:Generator_RowEvHandlerName="Delete_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="Delete_WareRowDeleted" msprop:Generator_RowEvArgName="Delete_WareRowChangeEvent" msprop:Generator_RowChangedName="Delete_WareRowChanged" msprop:Generator_RowClassName="Delete_WareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="UnHide_Ware" msprop:Generator_TableClassName="UnHide_WareDataTable" msprop:Generator_TableVarName="tableUnHide_Ware" msprop:Generator_TablePropName="UnHide_Ware" msprop:Generator_RowDeletingName="UnHide_WareRowDeleting" msprop:Generator_UserTableName="UnHide_Ware" msprop:Generator_RowChangingName="UnHide_WareRowChanging" msprop:Generator_RowEvHandlerName="UnHide_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="UnHide_WareRowDeleted" msprop:Generator_RowEvArgName="UnHide_WareRowChangeEvent" msprop:Generator_RowChangedName="UnHide_WareRowChanged" msprop:Generator_RowClassName="UnHide_WareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Ware" msprop:Generator_TableClassName="GET_WareDataTable" msprop:Generator_TableVarName="tableGET_Ware" msprop:Generator_TablePropName="GET_Ware" msprop:Generator_RowDeletingName="GET_WareRowDeleting" msprop:Generator_UserTableName="GET_Ware" msprop:Generator_RowChangingName="GET_WareRowChanging" msprop:Generator_RowEvHandlerName="GET_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WareRowDeleted" msprop:Generator_RowEvArgName="GET_WareRowChangeEvent" msprop:Generator_RowChangedName="GET_WareRowChanged" msprop:Generator_RowClassName="GET_WareRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WaresID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWaresID" msprop:Generator_ColumnPropNameInRow="WaresID" msprop:Generator_ColumnPropNameInTable="WaresIDColumn" msprop:Generator_UserColumnName="WaresID" type="xs:string" />
              <xs:element name="WareName" msprop:Generator_ColumnVarNameInTable="columnWareName" msprop:Generator_ColumnPropNameInRow="WareName" msprop:Generator_ColumnPropNameInTable="WareNameColumn" msprop:Generator_UserColumnName="WareName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDesc" msprop:Generator_ColumnVarNameInTable="columnShortDesc" msprop:Generator_ColumnPropNameInRow="ShortDesc" msprop:Generator_ColumnPropNameInTable="ShortDescColumn" msprop:Generator_UserColumnName="ShortDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDesc" msprop:Generator_ColumnVarNameInTable="columnFullDesc" msprop:Generator_ColumnPropNameInRow="FullDesc" msprop:Generator_ColumnPropNameInTable="FullDescColumn" msprop:Generator_UserColumnName="FullDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SHCode" msprop:Generator_ColumnVarNameInTable="columnSHCode" msprop:Generator_ColumnPropNameInRow="SHCode" msprop:Generator_ColumnPropNameInTable="SHCodeColumn" msprop:Generator_UserColumnName="SHCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceMain" msprop:Generator_ColumnVarNameInTable="columnPriceMain" msprop:Generator_ColumnPropNameInRow="PriceMain" msprop:Generator_ColumnPropNameInTable="PriceMainColumn" msprop:Generator_UserColumnName="PriceMain" type="xs:decimal" />
              <xs:element name="PriceRed" msprop:Generator_ColumnVarNameInTable="columnPriceRed" msprop:Generator_ColumnPropNameInRow="PriceRed" msprop:Generator_ColumnPropNameInTable="PriceRedColumn" msprop:Generator_UserColumnName="PriceRed" type="xs:decimal" minOccurs="0" />
              <xs:element name="GroupID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGroupID" msprop:Generator_ColumnPropNameInRow="GroupID" msprop:Generator_ColumnPropNameInTable="GroupIDColumn" msprop:Generator_UserColumnName="GroupID" type="xs:string" minOccurs="0" />
              <xs:element name="NettoWeight" msprop:Generator_ColumnVarNameInTable="columnNettoWeight" msprop:Generator_ColumnPropNameInRow="NettoWeight" msprop:Generator_ColumnPropNameInTable="NettoWeightColumn" msprop:Generator_UserColumnName="NettoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="BruttoWeight" msprop:Generator_ColumnVarNameInTable="columnBruttoWeight" msprop:Generator_ColumnPropNameInRow="BruttoWeight" msprop:Generator_ColumnPropNameInTable="BruttoWeightColumn" msprop:Generator_UserColumnName="BruttoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="Recipe" msprop:Generator_ColumnVarNameInTable="columnRecipe" msprop:Generator_ColumnPropNameInRow="Recipe" msprop:Generator_ColumnPropNameInTable="RecipeColumn" msprop:Generator_UserColumnName="Recipe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceCategory" msprop:Generator_ColumnVarNameInTable="columnPriceCategory" msprop:Generator_ColumnPropNameInRow="PriceCategory" msprop:Generator_ColumnPropNameInTable="PriceCategoryColumn" msprop:Generator_UserColumnName="PriceCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Staff" msprop:Generator_ColumnVarNameInTable="columnStaff" msprop:Generator_ColumnPropNameInRow="Staff" msprop:Generator_ColumnPropNameInTable="StaffColumn" msprop:Generator_UserColumnName="Staff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffListGuid" msprop:Generator_ColumnVarNameInTable="columnStaffListGuid" msprop:Generator_ColumnPropNameInRow="StaffListGuid" msprop:Generator_ColumnPropNameInTable="StaffListGuidColumn" msprop:Generator_UserColumnName="StaffListGuid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidBefore" msprop:Generator_ColumnVarNameInTable="columnValidBefore" msprop:Generator_ColumnPropNameInRow="ValidBefore" msprop:Generator_ColumnPropNameInTable="ValidBeforeColumn" msprop:Generator_UserColumnName="ValidBefore" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conditions" msprop:Generator_ColumnVarNameInTable="columnConditions" msprop:Generator_ColumnPropNameInRow="Conditions" msprop:Generator_ColumnPropNameInTable="ConditionsColumn" msprop:Generator_UserColumnName="Conditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Protein" msprop:Generator_ColumnVarNameInTable="columnProtein" msprop:Generator_ColumnPropNameInRow="Protein" msprop:Generator_ColumnPropNameInTable="ProteinColumn" msprop:Generator_UserColumnName="Protein" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fat" msprop:Generator_ColumnVarNameInTable="columnFat" msprop:Generator_ColumnPropNameInRow="Fat" msprop:Generator_ColumnPropNameInTable="FatColumn" msprop:Generator_UserColumnName="Fat" type="xs:decimal" minOccurs="0" />
              <xs:element name="Carbonhydrates" msprop:Generator_ColumnVarNameInTable="columnCarbonhydrates" msprop:Generator_ColumnPropNameInRow="Carbonhydrates" msprop:Generator_ColumnPropNameInTable="CarbonhydratesColumn" msprop:Generator_UserColumnName="Carbonhydrates" type="xs:decimal" minOccurs="0" />
              <xs:element name="EnergyValue" msprop:Generator_ColumnVarNameInTable="columnEnergyValue" msprop:Generator_ColumnPropNameInRow="EnergyValue" msprop:Generator_ColumnPropNameInTable="EnergyValueColumn" msprop:Generator_UserColumnName="EnergyValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareCategory" msprop:Generator_ColumnVarNameInTable="columnWareCategory" msprop:Generator_ColumnPropNameInRow="WareCategory" msprop:Generator_ColumnPropNameInTable="WareCategoryColumn" msprop:Generator_UserColumnName="WareCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="DateUpdatePrice" msprop:Generator_ColumnVarNameInTable="columnDateUpdatePrice" msprop:Generator_ColumnPropNameInRow="DateUpdatePrice" msprop:Generator_ColumnPropNameInTable="DateUpdatePriceColumn" msprop:Generator_UserColumnName="DateUpdatePrice" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Counter" msprop:Generator_ColumnVarNameInTable="columnCounter" msprop:Generator_ColumnPropNameInRow="Counter" msprop:Generator_ColumnPropNameInTable="CounterColumn" msprop:Generator_UserColumnName="Counter" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" />
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" minOccurs="0" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LiveID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLiveID" msprop:Generator_ColumnPropNameInRow="LiveID" msprop:Generator_ColumnPropNameInTable="LiveIDColumn" msprop:Generator_UserColumnName="LiveID" type="xs:string" minOccurs="0" />
              <xs:element name="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsHidden" msprop:Generator_ColumnVarNameInTable="columnIsHidden" msprop:Generator_ColumnPropNameInRow="IsHidden" msprop:Generator_ColumnPropNameInTable="IsHiddenColumn" msprop:Generator_UserColumnName="IsHidden" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UPDATE_Ware" msprop:Generator_TableClassName="UPDATE_WareDataTable" msprop:Generator_TableVarName="tableUPDATE_Ware" msprop:Generator_TablePropName="UPDATE_Ware" msprop:Generator_RowDeletingName="UPDATE_WareRowDeleting" msprop:Generator_UserTableName="UPDATE_Ware" msprop:Generator_RowChangingName="UPDATE_WareRowChanging" msprop:Generator_RowEvHandlerName="UPDATE_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="UPDATE_WareRowDeleted" msprop:Generator_RowEvArgName="UPDATE_WareRowChangeEvent" msprop:Generator_RowChangedName="UPDATE_WareRowChanged" msprop:Generator_RowClassName="UPDATE_WareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_WareBySHCode" msprop:Generator_TableClassName="GET_WareBySHCodeDataTable" msprop:Generator_TableVarName="tableGET_WareBySHCode" msprop:Generator_TablePropName="GET_WareBySHCode" msprop:Generator_RowDeletingName="GET_WareBySHCodeRowDeleting" msprop:Generator_UserTableName="GET_WareBySHCode" msprop:Generator_RowChangingName="GET_WareBySHCodeRowChanging" msprop:Generator_RowEvHandlerName="GET_WareBySHCodeRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WareBySHCodeRowDeleted" msprop:Generator_RowEvArgName="GET_WareBySHCodeRowChangeEvent" msprop:Generator_RowChangedName="GET_WareBySHCodeRowChanged" msprop:Generator_RowClassName="GET_WareBySHCodeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WaresID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWaresID" msprop:Generator_ColumnPropNameInRow="WaresID" msprop:Generator_ColumnPropNameInTable="WaresIDColumn" msprop:Generator_UserColumnName="WaresID" type="xs:string" />
              <xs:element name="WareName" msprop:Generator_ColumnVarNameInTable="columnWareName" msprop:Generator_ColumnPropNameInRow="WareName" msprop:Generator_ColumnPropNameInTable="WareNameColumn" msprop:Generator_UserColumnName="WareName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDesc" msprop:Generator_ColumnVarNameInTable="columnShortDesc" msprop:Generator_ColumnPropNameInRow="ShortDesc" msprop:Generator_ColumnPropNameInTable="ShortDescColumn" msprop:Generator_UserColumnName="ShortDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDesc" msprop:Generator_ColumnVarNameInTable="columnFullDesc" msprop:Generator_ColumnPropNameInRow="FullDesc" msprop:Generator_ColumnPropNameInTable="FullDescColumn" msprop:Generator_UserColumnName="FullDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SHCode" msprop:Generator_ColumnVarNameInTable="columnSHCode" msprop:Generator_ColumnPropNameInRow="SHCode" msprop:Generator_ColumnPropNameInTable="SHCodeColumn" msprop:Generator_UserColumnName="SHCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceMain" msprop:Generator_ColumnVarNameInTable="columnPriceMain" msprop:Generator_ColumnPropNameInRow="PriceMain" msprop:Generator_ColumnPropNameInTable="PriceMainColumn" msprop:Generator_UserColumnName="PriceMain" type="xs:decimal" />
              <xs:element name="PriceRed" msprop:Generator_ColumnVarNameInTable="columnPriceRed" msprop:Generator_ColumnPropNameInRow="PriceRed" msprop:Generator_ColumnPropNameInTable="PriceRedColumn" msprop:Generator_UserColumnName="PriceRed" type="xs:decimal" minOccurs="0" />
              <xs:element name="GroupID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGroupID" msprop:Generator_ColumnPropNameInRow="GroupID" msprop:Generator_ColumnPropNameInTable="GroupIDColumn" msprop:Generator_UserColumnName="GroupID" type="xs:string" minOccurs="0" />
              <xs:element name="NettoWeight" msprop:Generator_ColumnVarNameInTable="columnNettoWeight" msprop:Generator_ColumnPropNameInRow="NettoWeight" msprop:Generator_ColumnPropNameInTable="NettoWeightColumn" msprop:Generator_UserColumnName="NettoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="BruttoWeight" msprop:Generator_ColumnVarNameInTable="columnBruttoWeight" msprop:Generator_ColumnPropNameInRow="BruttoWeight" msprop:Generator_ColumnPropNameInTable="BruttoWeightColumn" msprop:Generator_UserColumnName="BruttoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="Recipe" msprop:Generator_ColumnVarNameInTable="columnRecipe" msprop:Generator_ColumnPropNameInRow="Recipe" msprop:Generator_ColumnPropNameInTable="RecipeColumn" msprop:Generator_UserColumnName="Recipe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceCategory" msprop:Generator_ColumnVarNameInTable="columnPriceCategory" msprop:Generator_ColumnPropNameInRow="PriceCategory" msprop:Generator_ColumnPropNameInTable="PriceCategoryColumn" msprop:Generator_UserColumnName="PriceCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Staff" msprop:Generator_ColumnVarNameInTable="columnStaff" msprop:Generator_ColumnPropNameInRow="Staff" msprop:Generator_ColumnPropNameInTable="StaffColumn" msprop:Generator_UserColumnName="Staff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffListGuid" msprop:Generator_ColumnVarNameInTable="columnStaffListGuid" msprop:Generator_ColumnPropNameInRow="StaffListGuid" msprop:Generator_ColumnPropNameInTable="StaffListGuidColumn" msprop:Generator_UserColumnName="StaffListGuid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidBefore" msprop:Generator_ColumnVarNameInTable="columnValidBefore" msprop:Generator_ColumnPropNameInRow="ValidBefore" msprop:Generator_ColumnPropNameInTable="ValidBeforeColumn" msprop:Generator_UserColumnName="ValidBefore" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conditions" msprop:Generator_ColumnVarNameInTable="columnConditions" msprop:Generator_ColumnPropNameInRow="Conditions" msprop:Generator_ColumnPropNameInTable="ConditionsColumn" msprop:Generator_UserColumnName="Conditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Protein" msprop:Generator_ColumnVarNameInTable="columnProtein" msprop:Generator_ColumnPropNameInRow="Protein" msprop:Generator_ColumnPropNameInTable="ProteinColumn" msprop:Generator_UserColumnName="Protein" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fat" msprop:Generator_ColumnVarNameInTable="columnFat" msprop:Generator_ColumnPropNameInRow="Fat" msprop:Generator_ColumnPropNameInTable="FatColumn" msprop:Generator_UserColumnName="Fat" type="xs:decimal" minOccurs="0" />
              <xs:element name="Carbonhydrates" msprop:Generator_ColumnVarNameInTable="columnCarbonhydrates" msprop:Generator_ColumnPropNameInRow="Carbonhydrates" msprop:Generator_ColumnPropNameInTable="CarbonhydratesColumn" msprop:Generator_UserColumnName="Carbonhydrates" type="xs:decimal" minOccurs="0" />
              <xs:element name="EnergyValue" msprop:Generator_ColumnVarNameInTable="columnEnergyValue" msprop:Generator_ColumnPropNameInRow="EnergyValue" msprop:Generator_ColumnPropNameInTable="EnergyValueColumn" msprop:Generator_UserColumnName="EnergyValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareCategory" msprop:Generator_ColumnVarNameInTable="columnWareCategory" msprop:Generator_ColumnPropNameInRow="WareCategory" msprop:Generator_ColumnPropNameInTable="WareCategoryColumn" msprop:Generator_UserColumnName="WareCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="DateUpdatePrice" msprop:Generator_ColumnVarNameInTable="columnDateUpdatePrice" msprop:Generator_ColumnPropNameInRow="DateUpdatePrice" msprop:Generator_ColumnPropNameInTable="DateUpdatePriceColumn" msprop:Generator_UserColumnName="DateUpdatePrice" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Counter" msprop:Generator_ColumnVarNameInTable="columnCounter" msprop:Generator_ColumnPropNameInRow="Counter" msprop:Generator_ColumnPropNameInTable="CounterColumn" msprop:Generator_UserColumnName="Counter" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" />
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" minOccurs="0" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LiveID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLiveID" msprop:Generator_ColumnPropNameInRow="LiveID" msprop:Generator_ColumnPropNameInTable="LiveIDColumn" msprop:Generator_UserColumnName="LiveID" type="xs:string" minOccurs="0" />
              <xs:element name="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsHidden" msprop:Generator_ColumnVarNameInTable="columnIsHidden" msprop:Generator_ColumnPropNameInRow="IsHidden" msprop:Generator_ColumnPropNameInTable="IsHiddenColumn" msprop:Generator_UserColumnName="IsHidden" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_WareAction" msprop:Generator_TableClassName="ADD_WareActionDataTable" msprop:Generator_TableVarName="tableADD_WareAction" msprop:Generator_TablePropName="ADD_WareAction" msprop:Generator_RowDeletingName="ADD_WareActionRowDeleting" msprop:Generator_UserTableName="ADD_WareAction" msprop:Generator_RowChangingName="ADD_WareActionRowChanging" msprop:Generator_RowEvHandlerName="ADD_WareActionRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_WareActionRowDeleted" msprop:Generator_RowEvArgName="ADD_WareActionRowChangeEvent" msprop:Generator_RowChangedName="ADD_WareActionRowChanged" msprop:Generator_RowClassName="ADD_WareActionRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_WareForChanges" msprop:Generator_TableClassName="ADD_WareForChangesDataTable" msprop:Generator_TableVarName="tableADD_WareForChanges" msprop:Generator_TablePropName="ADD_WareForChanges" msprop:Generator_RowDeletingName="ADD_WareForChangesRowDeleting" msprop:Generator_UserTableName="ADD_WareForChanges" msprop:Generator_RowChangingName="ADD_WareForChangesRowChanging" msprop:Generator_RowEvHandlerName="ADD_WareForChangesRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_WareForChangesRowDeleted" msprop:Generator_RowEvArgName="ADD_WareForChangesRowChangeEvent" msprop:Generator_RowChangedName="ADD_WareForChangesRowChanged" msprop:Generator_RowClassName="ADD_WareForChangesRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="REMOVE_WaresForChanges" msprop:Generator_TableClassName="REMOVE_WaresForChangesDataTable" msprop:Generator_TableVarName="tableREMOVE_WaresForChanges" msprop:Generator_TablePropName="REMOVE_WaresForChanges" msprop:Generator_RowDeletingName="REMOVE_WaresForChangesRowDeleting" msprop:Generator_UserTableName="REMOVE_WaresForChanges" msprop:Generator_RowChangingName="REMOVE_WaresForChangesRowChanging" msprop:Generator_RowEvHandlerName="REMOVE_WaresForChangesRowChangeEventHandler" msprop:Generator_RowDeletedName="REMOVE_WaresForChangesRowDeleted" msprop:Generator_RowEvArgName="REMOVE_WaresForChangesRowChangeEvent" msprop:Generator_RowChangedName="REMOVE_WaresForChangesRowChanged" msprop:Generator_RowClassName="REMOVE_WaresForChangesRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_WareActions" msprop:Generator_TableClassName="GET_WareActionsDataTable" msprop:Generator_TableVarName="tableGET_WareActions" msprop:Generator_TablePropName="GET_WareActions" msprop:Generator_RowDeletingName="GET_WareActionsRowDeleting" msprop:Generator_UserTableName="GET_WareActions" msprop:Generator_RowChangingName="GET_WareActionsRowChanging" msprop:Generator_RowEvHandlerName="GET_WareActionsRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WareActionsRowDeleted" msprop:Generator_RowEvArgName="GET_WareActionsRowChangeEvent" msprop:Generator_RowChangedName="GET_WareActionsRowChanged" msprop:Generator_RowClassName="GET_WareActionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActionID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn" msprop:Generator_UserColumnName="ActionID" type="xs:string" />
              <xs:element name="WareID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWareID" msprop:Generator_ColumnPropNameInRow="WareID" msprop:Generator_ColumnPropNameInTable="WareIDColumn" msprop:Generator_UserColumnName="WareID" type="xs:string" />
              <xs:element name="ManagerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnManagerID" msprop:Generator_ColumnPropNameInRow="ManagerID" msprop:Generator_ColumnPropNameInTable="ManagerIDColumn" msprop:Generator_UserColumnName="ManagerID" type="xs:string" />
              <xs:element name="UpdateTime" msprop:Generator_ColumnVarNameInTable="columnUpdateTime" msprop:Generator_ColumnPropNameInRow="UpdateTime" msprop:Generator_ColumnPropNameInTable="UpdateTimeColumn" msprop:Generator_UserColumnName="UpdateTime">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_WareActionsByManager" msprop:Generator_TableClassName="GET_WareActionsByManagerDataTable" msprop:Generator_TableVarName="tableGET_WareActionsByManager" msprop:Generator_TablePropName="GET_WareActionsByManager" msprop:Generator_RowDeletingName="GET_WareActionsByManagerRowDeleting" msprop:Generator_UserTableName="GET_WareActionsByManager" msprop:Generator_RowChangingName="GET_WareActionsByManagerRowChanging" msprop:Generator_RowEvHandlerName="GET_WareActionsByManagerRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WareActionsByManagerRowDeleted" msprop:Generator_RowEvArgName="GET_WareActionsByManagerRowChangeEvent" msprop:Generator_RowChangedName="GET_WareActionsByManagerRowChanged" msprop:Generator_RowClassName="GET_WareActionsByManagerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActionID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn" msprop:Generator_UserColumnName="ActionID" type="xs:string" />
              <xs:element name="WareID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWareID" msprop:Generator_ColumnPropNameInRow="WareID" msprop:Generator_ColumnPropNameInTable="WareIDColumn" msprop:Generator_UserColumnName="WareID" type="xs:string" />
              <xs:element name="ManagerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnManagerID" msprop:Generator_ColumnPropNameInRow="ManagerID" msprop:Generator_ColumnPropNameInTable="ManagerIDColumn" msprop:Generator_UserColumnName="ManagerID" type="xs:string" />
              <xs:element name="UpdateTime" msprop:Generator_ColumnVarNameInTable="columnUpdateTime" msprop:Generator_ColumnPropNameInRow="UpdateTime" msprop:Generator_ColumnPropNameInTable="UpdateTimeColumn" msprop:Generator_UserColumnName="UpdateTime">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_AllWareActions" msprop:Generator_TableClassName="GET_AllWareActionsDataTable" msprop:Generator_TableVarName="tableGET_AllWareActions" msprop:Generator_TablePropName="GET_AllWareActions" msprop:Generator_RowDeletingName="GET_AllWareActionsRowDeleting" msprop:Generator_UserTableName="GET_AllWareActions" msprop:Generator_RowChangingName="GET_AllWareActionsRowChanging" msprop:Generator_RowEvHandlerName="GET_AllWareActionsRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_AllWareActionsRowDeleted" msprop:Generator_RowEvArgName="GET_AllWareActionsRowChangeEvent" msprop:Generator_RowChangedName="GET_AllWareActionsRowChanged" msprop:Generator_RowClassName="GET_AllWareActionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActionID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnActionID" msprop:Generator_ColumnPropNameInRow="ActionID" msprop:Generator_ColumnPropNameInTable="ActionIDColumn" msprop:Generator_UserColumnName="ActionID" type="xs:string" />
              <xs:element name="WareID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWareID" msprop:Generator_ColumnPropNameInRow="WareID" msprop:Generator_ColumnPropNameInTable="WareIDColumn" msprop:Generator_UserColumnName="WareID" type="xs:string" />
              <xs:element name="ManagerID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnManagerID" msprop:Generator_ColumnPropNameInRow="ManagerID" msprop:Generator_ColumnPropNameInTable="ManagerIDColumn" msprop:Generator_UserColumnName="ManagerID" type="xs:string" />
              <xs:element name="UpdateTime" msprop:Generator_ColumnVarNameInTable="columnUpdateTime" msprop:Generator_ColumnPropNameInRow="UpdateTime" msprop:Generator_ColumnPropNameInTable="UpdateTimeColumn" msprop:Generator_UserColumnName="UpdateTime">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_ClientVerification" msprop:Generator_TableClassName="GET_ClientVerificationDataTable" msprop:Generator_TableVarName="tableGET_ClientVerification" msprop:Generator_TablePropName="GET_ClientVerification" msprop:Generator_RowDeletingName="GET_ClientVerificationRowDeleting" msprop:Generator_UserTableName="GET_ClientVerification" msprop:Generator_RowChangingName="GET_ClientVerificationRowChanging" msprop:Generator_RowEvHandlerName="GET_ClientVerificationRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ClientVerificationRowDeleted" msprop:Generator_RowEvArgName="GET_ClientVerificationRowChangeEvent" msprop:Generator_RowChangedName="GET_ClientVerificationRowChanged" msprop:Generator_RowClassName="GET_ClientVerificationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ClientID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:string" minOccurs="0" />
              <xs:element name="IsSuccessful" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnIsSuccessful" msprop:Generator_ColumnPropNameInRow="IsSuccessful" msprop:Generator_ColumnPropNameInTable="IsSuccessfulColumn" msprop:Generator_UserColumnName="IsSuccessful" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_IsFavoriteWare" msprop:Generator_TableClassName="GET_IsFavoriteWareDataTable" msprop:Generator_TableVarName="tableGET_IsFavoriteWare" msprop:Generator_TablePropName="GET_IsFavoriteWare" msprop:Generator_RowDeletingName="GET_IsFavoriteWareRowDeleting" msprop:Generator_UserTableName="GET_IsFavoriteWare" msprop:Generator_RowChangingName="GET_IsFavoriteWareRowChanging" msprop:Generator_RowEvHandlerName="GET_IsFavoriteWareRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_IsFavoriteWareRowDeleted" msprop:Generator_RowEvArgName="GET_IsFavoriteWareRowChangeEvent" msprop:Generator_RowChangedName="GET_IsFavoriteWareRowChanged" msprop:Generator_RowClassName="GET_IsFavoriteWareRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IsFavorite" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnIsFavorite" msprop:Generator_ColumnPropNameInRow="IsFavorite" msprop:Generator_ColumnPropNameInTable="IsFavoriteColumn" msprop:Generator_UserColumnName="IsFavorite" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_IsMarkedWare" msprop:Generator_TableClassName="GET_IsMarkedWareDataTable" msprop:Generator_TableVarName="tableGET_IsMarkedWare" msprop:Generator_TablePropName="GET_IsMarkedWare" msprop:Generator_RowDeletingName="GET_IsMarkedWareRowDeleting" msprop:Generator_UserTableName="GET_IsMarkedWare" msprop:Generator_RowChangingName="GET_IsMarkedWareRowChanging" msprop:Generator_RowEvHandlerName="GET_IsMarkedWareRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_IsMarkedWareRowDeleted" msprop:Generator_RowEvArgName="GET_IsMarkedWareRowChangeEvent" msprop:Generator_RowChangedName="GET_IsMarkedWareRowChanged" msprop:Generator_RowClassName="GET_IsMarkedWareRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IsMarked" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnIsMarked" msprop:Generator_ColumnPropNameInRow="IsMarked" msprop:Generator_ColumnPropNameInTable="IsMarkedColumn" msprop:Generator_UserColumnName="IsMarked" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_FavoriteWare" msprop:Generator_TableClassName="ADD_FavoriteWareDataTable" msprop:Generator_TableVarName="tableADD_FavoriteWare" msprop:Generator_TablePropName="ADD_FavoriteWare" msprop:Generator_RowDeletingName="ADD_FavoriteWareRowDeleting" msprop:Generator_UserTableName="ADD_FavoriteWare" msprop:Generator_RowChangingName="ADD_FavoriteWareRowChanging" msprop:Generator_RowEvHandlerName="ADD_FavoriteWareRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_FavoriteWareRowDeleted" msprop:Generator_RowEvArgName="ADD_FavoriteWareRowChangeEvent" msprop:Generator_RowChangedName="ADD_FavoriteWareRowChanged" msprop:Generator_RowClassName="ADD_FavoriteWareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_StaffList" msprop:Generator_TableClassName="GET_StaffListDataTable" msprop:Generator_TableVarName="tableGET_StaffList" msprop:Generator_TablePropName="GET_StaffList" msprop:Generator_RowDeletingName="GET_StaffListRowDeleting" msprop:Generator_UserTableName="GET_StaffList" msprop:Generator_RowChangingName="GET_StaffListRowChanging" msprop:Generator_RowEvHandlerName="GET_StaffListRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_StaffListRowDeleted" msprop:Generator_RowEvArgName="GET_StaffListRowChangeEvent" msprop:Generator_RowChangedName="GET_StaffListRowChanged" msprop:Generator_RowClassName="GET_StaffListRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IngridientID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnIngridientID" msprop:Generator_ColumnPropNameInRow="IngridientID" msprop:Generator_ColumnPropNameInTable="IngridientIDColumn" msprop:Generator_UserColumnName="IngridientID" type="xs:string" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" msprop:Generator_UserColumnName="Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_CheckList" msprop:Generator_TableClassName="GET_CheckListDataTable" msprop:Generator_TableVarName="tableGET_CheckList" msprop:Generator_TablePropName="GET_CheckList" msprop:Generator_RowDeletingName="GET_CheckListRowDeleting" msprop:Generator_UserTableName="GET_CheckList" msprop:Generator_RowChangingName="GET_CheckListRowChanging" msprop:Generator_RowEvHandlerName="GET_CheckListRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_CheckListRowDeleted" msprop:Generator_RowEvArgName="GET_CheckListRowChangeEvent" msprop:Generator_RowChangedName="GET_CheckListRowChanged" msprop:Generator_RowClassName="GET_CheckListRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CheckID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCheckID" msprop:Generator_ColumnPropNameInRow="CheckID" msprop:Generator_ColumnPropNameInTable="CheckIDColumn" msprop:Generator_UserColumnName="CheckID" type="xs:string" />
              <xs:element name="CheckListID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCheckListID" msprop:Generator_ColumnPropNameInRow="CheckListID" msprop:Generator_ColumnPropNameInTable="CheckListIDColumn" msprop:Generator_UserColumnName="CheckListID" type="xs:string" />
              <xs:element name="ClientID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:string" />
              <xs:element name="WareID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWareID" msprop:Generator_ColumnPropNameInRow="WareID" msprop:Generator_ColumnPropNameInTable="WareIDColumn" msprop:Generator_UserColumnName="WareID" type="xs:string" />
              <xs:element name="Count" msprop:Generator_ColumnVarNameInTable="columnCount" msprop:Generator_ColumnPropNameInRow="Count" msprop:Generator_ColumnPropNameInTable="CountColumn" msprop:Generator_UserColumnName="Count" type="xs:int" minOccurs="0" />
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="Weigh" msprop:Generator_ColumnVarNameInTable="columnWeigh" msprop:Generator_ColumnPropNameInRow="Weigh" msprop:Generator_ColumnPropNameInTable="WeighColumn" msprop:Generator_UserColumnName="Weigh" type="xs:decimal" minOccurs="0" />
              <xs:element name="IsChecked" msprop:Generator_ColumnVarNameInTable="columnIsChecked" msprop:Generator_ColumnPropNameInRow="IsChecked" msprop:Generator_ColumnPropNameInTable="IsCheckedColumn" msprop:Generator_UserColumnName="IsChecked" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_ClientCheckLists" msprop:Generator_TableClassName="GET_ClientCheckListsDataTable" msprop:Generator_TableVarName="tableGET_ClientCheckLists" msprop:Generator_TablePropName="GET_ClientCheckLists" msprop:Generator_RowDeletingName="GET_ClientCheckListsRowDeleting" msprop:Generator_UserTableName="GET_ClientCheckLists" msprop:Generator_RowChangingName="GET_ClientCheckListsRowChanging" msprop:Generator_RowEvHandlerName="GET_ClientCheckListsRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ClientCheckListsRowDeleted" msprop:Generator_RowEvArgName="GET_ClientCheckListsRowChangeEvent" msprop:Generator_RowChangedName="GET_ClientCheckListsRowChanged" msprop:Generator_RowClassName="GET_ClientCheckListsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CheckListID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCheckListID" msprop:Generator_ColumnPropNameInRow="CheckListID" msprop:Generator_ColumnPropNameInTable="CheckListIDColumn" msprop:Generator_UserColumnName="CheckListID" type="xs:string" />
              <xs:element name="ClientID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_WareAnalogs" msprop:Generator_TableClassName="GET_WareAnalogsDataTable" msprop:Generator_TableVarName="tableGET_WareAnalogs" msprop:Generator_TablePropName="GET_WareAnalogs" msprop:Generator_RowDeletingName="GET_WareAnalogsRowDeleting" msprop:Generator_UserTableName="GET_WareAnalogs" msprop:Generator_RowChangingName="GET_WareAnalogsRowChanging" msprop:Generator_RowEvHandlerName="GET_WareAnalogsRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WareAnalogsRowDeleted" msprop:Generator_RowEvArgName="GET_WareAnalogsRowChangeEvent" msprop:Generator_RowChangedName="GET_WareAnalogsRowChanged" msprop:Generator_RowClassName="GET_WareAnalogsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WaresID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWaresID" msprop:Generator_ColumnPropNameInRow="WaresID" msprop:Generator_ColumnPropNameInTable="WaresIDColumn" msprop:Generator_UserColumnName="WaresID" type="xs:string" />
              <xs:element name="WareName" msprop:Generator_ColumnVarNameInTable="columnWareName" msprop:Generator_ColumnPropNameInRow="WareName" msprop:Generator_ColumnPropNameInTable="WareNameColumn" msprop:Generator_UserColumnName="WareName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDesc" msprop:Generator_ColumnVarNameInTable="columnShortDesc" msprop:Generator_ColumnPropNameInRow="ShortDesc" msprop:Generator_ColumnPropNameInTable="ShortDescColumn" msprop:Generator_UserColumnName="ShortDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDesc" msprop:Generator_ColumnVarNameInTable="columnFullDesc" msprop:Generator_ColumnPropNameInRow="FullDesc" msprop:Generator_ColumnPropNameInTable="FullDescColumn" msprop:Generator_UserColumnName="FullDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SHCode" msprop:Generator_ColumnVarNameInTable="columnSHCode" msprop:Generator_ColumnPropNameInRow="SHCode" msprop:Generator_ColumnPropNameInTable="SHCodeColumn" msprop:Generator_UserColumnName="SHCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceMain" msprop:Generator_ColumnVarNameInTable="columnPriceMain" msprop:Generator_ColumnPropNameInRow="PriceMain" msprop:Generator_ColumnPropNameInTable="PriceMainColumn" msprop:Generator_UserColumnName="PriceMain" type="xs:decimal" />
              <xs:element name="PriceRed" msprop:Generator_ColumnVarNameInTable="columnPriceRed" msprop:Generator_ColumnPropNameInRow="PriceRed" msprop:Generator_ColumnPropNameInTable="PriceRedColumn" msprop:Generator_UserColumnName="PriceRed" type="xs:decimal" minOccurs="0" />
              <xs:element name="GroupID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGroupID" msprop:Generator_ColumnPropNameInRow="GroupID" msprop:Generator_ColumnPropNameInTable="GroupIDColumn" msprop:Generator_UserColumnName="GroupID" type="xs:string" minOccurs="0" />
              <xs:element name="NettoWeight" msprop:Generator_ColumnVarNameInTable="columnNettoWeight" msprop:Generator_ColumnPropNameInRow="NettoWeight" msprop:Generator_ColumnPropNameInTable="NettoWeightColumn" msprop:Generator_UserColumnName="NettoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="BruttoWeight" msprop:Generator_ColumnVarNameInTable="columnBruttoWeight" msprop:Generator_ColumnPropNameInRow="BruttoWeight" msprop:Generator_ColumnPropNameInTable="BruttoWeightColumn" msprop:Generator_UserColumnName="BruttoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="Recipe" msprop:Generator_ColumnVarNameInTable="columnRecipe" msprop:Generator_ColumnPropNameInRow="Recipe" msprop:Generator_ColumnPropNameInTable="RecipeColumn" msprop:Generator_UserColumnName="Recipe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceCategory" msprop:Generator_ColumnVarNameInTable="columnPriceCategory" msprop:Generator_ColumnPropNameInRow="PriceCategory" msprop:Generator_ColumnPropNameInTable="PriceCategoryColumn" msprop:Generator_UserColumnName="PriceCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Staff" msprop:Generator_ColumnVarNameInTable="columnStaff" msprop:Generator_ColumnPropNameInRow="Staff" msprop:Generator_ColumnPropNameInTable="StaffColumn" msprop:Generator_UserColumnName="Staff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffListGuid" msprop:Generator_ColumnVarNameInTable="columnStaffListGuid" msprop:Generator_ColumnPropNameInRow="StaffListGuid" msprop:Generator_ColumnPropNameInTable="StaffListGuidColumn" msprop:Generator_UserColumnName="StaffListGuid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidBefore" msprop:Generator_ColumnVarNameInTable="columnValidBefore" msprop:Generator_ColumnPropNameInRow="ValidBefore" msprop:Generator_ColumnPropNameInTable="ValidBeforeColumn" msprop:Generator_UserColumnName="ValidBefore" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conditions" msprop:Generator_ColumnVarNameInTable="columnConditions" msprop:Generator_ColumnPropNameInRow="Conditions" msprop:Generator_ColumnPropNameInTable="ConditionsColumn" msprop:Generator_UserColumnName="Conditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Protein" msprop:Generator_ColumnVarNameInTable="columnProtein" msprop:Generator_ColumnPropNameInRow="Protein" msprop:Generator_ColumnPropNameInTable="ProteinColumn" msprop:Generator_UserColumnName="Protein" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fat" msprop:Generator_ColumnVarNameInTable="columnFat" msprop:Generator_ColumnPropNameInRow="Fat" msprop:Generator_ColumnPropNameInTable="FatColumn" msprop:Generator_UserColumnName="Fat" type="xs:decimal" minOccurs="0" />
              <xs:element name="Carbonhydrates" msprop:Generator_ColumnVarNameInTable="columnCarbonhydrates" msprop:Generator_ColumnPropNameInRow="Carbonhydrates" msprop:Generator_ColumnPropNameInTable="CarbonhydratesColumn" msprop:Generator_UserColumnName="Carbonhydrates" type="xs:decimal" minOccurs="0" />
              <xs:element name="EnergyValue" msprop:Generator_ColumnVarNameInTable="columnEnergyValue" msprop:Generator_ColumnPropNameInRow="EnergyValue" msprop:Generator_ColumnPropNameInTable="EnergyValueColumn" msprop:Generator_UserColumnName="EnergyValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareCategory" msprop:Generator_ColumnVarNameInTable="columnWareCategory" msprop:Generator_ColumnPropNameInRow="WareCategory" msprop:Generator_ColumnPropNameInTable="WareCategoryColumn" msprop:Generator_UserColumnName="WareCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="DateUpdatePrice" msprop:Generator_ColumnVarNameInTable="columnDateUpdatePrice" msprop:Generator_ColumnPropNameInRow="DateUpdatePrice" msprop:Generator_ColumnPropNameInTable="DateUpdatePriceColumn" msprop:Generator_UserColumnName="DateUpdatePrice" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Counter" msprop:Generator_ColumnVarNameInTable="columnCounter" msprop:Generator_ColumnPropNameInRow="Counter" msprop:Generator_ColumnPropNameInTable="CounterColumn" msprop:Generator_UserColumnName="Counter" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" />
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" minOccurs="0" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LiveID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLiveID" msprop:Generator_ColumnPropNameInRow="LiveID" msprop:Generator_ColumnPropNameInTable="LiveIDColumn" msprop:Generator_UserColumnName="LiveID" type="xs:string" minOccurs="0" />
              <xs:element name="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsHidden" msprop:Generator_ColumnVarNameInTable="columnIsHidden" msprop:Generator_ColumnPropNameInRow="IsHidden" msprop:Generator_ColumnPropNameInTable="IsHiddenColumn" msprop:Generator_UserColumnName="IsHidden" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SET_WarePrice" msprop:Generator_TableClassName="SET_WarePriceDataTable" msprop:Generator_TableVarName="tableSET_WarePrice" msprop:Generator_TablePropName="SET_WarePrice" msprop:Generator_RowDeletingName="SET_WarePriceRowDeleting" msprop:Generator_UserTableName="SET_WarePrice" msprop:Generator_RowChangingName="SET_WarePriceRowChanging" msprop:Generator_RowEvHandlerName="SET_WarePriceRowChangeEventHandler" msprop:Generator_RowDeletedName="SET_WarePriceRowDeleted" msprop:Generator_RowEvArgName="SET_WarePriceRowChangeEvent" msprop:Generator_RowChangedName="SET_WarePriceRowChanged" msprop:Generator_RowClassName="SET_WarePriceRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_WaresForChanges" msprop:Generator_TableClassName="GET_WaresForChangesDataTable" msprop:Generator_TableVarName="tableGET_WaresForChanges" msprop:Generator_TablePropName="GET_WaresForChanges" msprop:Generator_RowDeletingName="GET_WaresForChangesRowDeleting" msprop:Generator_UserTableName="GET_WaresForChanges" msprop:Generator_RowChangingName="GET_WaresForChangesRowChanging" msprop:Generator_RowEvHandlerName="GET_WaresForChangesRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WaresForChangesRowDeleted" msprop:Generator_RowEvArgName="GET_WaresForChangesRowChangeEvent" msprop:Generator_RowChangedName="GET_WaresForChangesRowChanged" msprop:Generator_RowClassName="GET_WaresForChangesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MarkID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnMarkID" msprop:Generator_ColumnPropNameInRow="MarkID" msprop:Generator_ColumnPropNameInTable="MarkIDColumn" msprop:Generator_UserColumnName="MarkID" type="xs:string" />
              <xs:element name="WareID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWareID" msprop:Generator_ColumnPropNameInRow="WareID" msprop:Generator_ColumnPropNameInTable="WareIDColumn" msprop:Generator_UserColumnName="WareID" type="xs:string" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClientID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnClientID" msprop:Generator_ColumnPropNameInRow="ClientID" msprop:Generator_ColumnPropNameInTable="ClientIDColumn" msprop:Generator_UserColumnName="ClientID" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_CategoryImport" msprop:Generator_TableClassName="ADD_CategoryImportDataTable" msprop:Generator_TableVarName="tableADD_CategoryImport" msprop:Generator_TablePropName="ADD_CategoryImport" msprop:Generator_RowDeletingName="ADD_CategoryImportRowDeleting" msprop:Generator_UserTableName="ADD_CategoryImport" msprop:Generator_RowChangingName="ADD_CategoryImportRowChanging" msprop:Generator_RowEvHandlerName="ADD_CategoryImportRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_CategoryImportRowDeleted" msprop:Generator_RowEvArgName="ADD_CategoryImportRowChangeEvent" msprop:Generator_RowChangedName="ADD_CategoryImportRowChanged" msprop:Generator_RowClassName="ADD_CategoryImportRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_ImportCategory" msprop:Generator_TableClassName="GET_ImportCategoryDataTable" msprop:Generator_TableVarName="tableGET_ImportCategory" msprop:Generator_TablePropName="GET_ImportCategory" msprop:Generator_RowDeletingName="GET_ImportCategoryRowDeleting" msprop:Generator_UserTableName="GET_ImportCategory" msprop:Generator_RowChangingName="GET_ImportCategoryRowChanging" msprop:Generator_RowEvHandlerName="GET_ImportCategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_ImportCategoryRowDeleted" msprop:Generator_RowEvArgName="GET_ImportCategoryRowChangeEvent" msprop:Generator_RowChangedName="GET_ImportCategoryRowChanged" msprop:Generator_RowClassName="GET_ImportCategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_Category" msprop:Generator_TableClassName="GET_CategoryDataTable" msprop:Generator_TableVarName="tableGET_Category" msprop:Generator_TablePropName="GET_Category" msprop:Generator_RowDeletingName="GET_CategoryRowDeleting" msprop:Generator_UserTableName="GET_Category" msprop:Generator_RowChangingName="GET_CategoryRowChanging" msprop:Generator_RowEvHandlerName="GET_CategoryRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_CategoryRowDeleted" msprop:Generator_RowEvArgName="GET_CategoryRowChangeEvent" msprop:Generator_RowChangedName="GET_CategoryRowChanged" msprop:Generator_RowClassName="GET_CategoryRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ParentID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" msprop:Generator_UserColumnName="ParentID" type="xs:string" minOccurs="0" />
              <xs:element name="Descriptin" msprop:Generator_ColumnVarNameInTable="columnDescriptin" msprop:Generator_ColumnPropNameInRow="Descriptin" msprop:Generator_ColumnPropNameInTable="DescriptinColumn" msprop:Generator_UserColumnName="Descriptin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_CategoryByName" msprop:Generator_TableClassName="GET_CategoryByNameDataTable" msprop:Generator_TableVarName="tableGET_CategoryByName" msprop:Generator_TablePropName="GET_CategoryByName" msprop:Generator_RowDeletingName="GET_CategoryByNameRowDeleting" msprop:Generator_UserTableName="GET_CategoryByName" msprop:Generator_RowChangingName="GET_CategoryByNameRowChanging" msprop:Generator_RowEvHandlerName="GET_CategoryByNameRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_CategoryByNameRowDeleted" msprop:Generator_RowEvArgName="GET_CategoryByNameRowChangeEvent" msprop:Generator_RowChangedName="GET_CategoryByNameRowChanged" msprop:Generator_RowClassName="GET_CategoryByNameRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" msprop:Generator_UserColumnName="CategoryID" type="xs:string" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ParentID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnParentID" msprop:Generator_ColumnPropNameInRow="ParentID" msprop:Generator_ColumnPropNameInTable="ParentIDColumn" msprop:Generator_UserColumnName="ParentID" type="xs:string" minOccurs="0" />
              <xs:element name="Descriptin" msprop:Generator_ColumnVarNameInTable="columnDescriptin" msprop:Generator_ColumnPropNameInRow="Descriptin" msprop:Generator_ColumnPropNameInTable="DescriptinColumn" msprop:Generator_UserColumnName="Descriptin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FIND_WareAnalogs" msprop:Generator_TableClassName="FIND_WareAnalogsDataTable" msprop:Generator_TableVarName="tableFIND_WareAnalogs" msprop:Generator_TablePropName="FIND_WareAnalogs" msprop:Generator_RowDeletingName="FIND_WareAnalogsRowDeleting" msprop:Generator_UserTableName="FIND_WareAnalogs" msprop:Generator_RowChangingName="FIND_WareAnalogsRowChanging" msprop:Generator_RowEvHandlerName="FIND_WareAnalogsRowChangeEventHandler" msprop:Generator_RowDeletedName="FIND_WareAnalogsRowDeleted" msprop:Generator_RowEvArgName="FIND_WareAnalogsRowChangeEvent" msprop:Generator_RowChangedName="FIND_WareAnalogsRowChanged" msprop:Generator_RowClassName="FIND_WareAnalogsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WaresID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWaresID" msprop:Generator_ColumnPropNameInRow="WaresID" msprop:Generator_ColumnPropNameInTable="WaresIDColumn" msprop:Generator_UserColumnName="WaresID" type="xs:string" />
              <xs:element name="WareName" msprop:Generator_ColumnVarNameInTable="columnWareName" msprop:Generator_ColumnPropNameInRow="WareName" msprop:Generator_ColumnPropNameInTable="WareNameColumn" msprop:Generator_UserColumnName="WareName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDesc" msprop:Generator_ColumnVarNameInTable="columnShortDesc" msprop:Generator_ColumnPropNameInRow="ShortDesc" msprop:Generator_ColumnPropNameInTable="ShortDescColumn" msprop:Generator_UserColumnName="ShortDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDesc" msprop:Generator_ColumnVarNameInTable="columnFullDesc" msprop:Generator_ColumnPropNameInRow="FullDesc" msprop:Generator_ColumnPropNameInTable="FullDescColumn" msprop:Generator_UserColumnName="FullDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SHCode" msprop:Generator_ColumnVarNameInTable="columnSHCode" msprop:Generator_ColumnPropNameInRow="SHCode" msprop:Generator_ColumnPropNameInTable="SHCodeColumn" msprop:Generator_UserColumnName="SHCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceMain" msprop:Generator_ColumnVarNameInTable="columnPriceMain" msprop:Generator_ColumnPropNameInRow="PriceMain" msprop:Generator_ColumnPropNameInTable="PriceMainColumn" msprop:Generator_UserColumnName="PriceMain" type="xs:decimal" />
              <xs:element name="PriceRed" msprop:Generator_ColumnVarNameInTable="columnPriceRed" msprop:Generator_ColumnPropNameInRow="PriceRed" msprop:Generator_ColumnPropNameInTable="PriceRedColumn" msprop:Generator_UserColumnName="PriceRed" type="xs:decimal" minOccurs="0" />
              <xs:element name="GroupID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGroupID" msprop:Generator_ColumnPropNameInRow="GroupID" msprop:Generator_ColumnPropNameInTable="GroupIDColumn" msprop:Generator_UserColumnName="GroupID" type="xs:string" minOccurs="0" />
              <xs:element name="NettoWeight" msprop:Generator_ColumnVarNameInTable="columnNettoWeight" msprop:Generator_ColumnPropNameInRow="NettoWeight" msprop:Generator_ColumnPropNameInTable="NettoWeightColumn" msprop:Generator_UserColumnName="NettoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="BruttoWeight" msprop:Generator_ColumnVarNameInTable="columnBruttoWeight" msprop:Generator_ColumnPropNameInRow="BruttoWeight" msprop:Generator_ColumnPropNameInTable="BruttoWeightColumn" msprop:Generator_UserColumnName="BruttoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="Recipe" msprop:Generator_ColumnVarNameInTable="columnRecipe" msprop:Generator_ColumnPropNameInRow="Recipe" msprop:Generator_ColumnPropNameInTable="RecipeColumn" msprop:Generator_UserColumnName="Recipe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceCategory" msprop:Generator_ColumnVarNameInTable="columnPriceCategory" msprop:Generator_ColumnPropNameInRow="PriceCategory" msprop:Generator_ColumnPropNameInTable="PriceCategoryColumn" msprop:Generator_UserColumnName="PriceCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Staff" msprop:Generator_ColumnVarNameInTable="columnStaff" msprop:Generator_ColumnPropNameInRow="Staff" msprop:Generator_ColumnPropNameInTable="StaffColumn" msprop:Generator_UserColumnName="Staff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffListGuid" msprop:Generator_ColumnVarNameInTable="columnStaffListGuid" msprop:Generator_ColumnPropNameInRow="StaffListGuid" msprop:Generator_ColumnPropNameInTable="StaffListGuidColumn" msprop:Generator_UserColumnName="StaffListGuid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidBefore" msprop:Generator_ColumnVarNameInTable="columnValidBefore" msprop:Generator_ColumnPropNameInRow="ValidBefore" msprop:Generator_ColumnPropNameInTable="ValidBeforeColumn" msprop:Generator_UserColumnName="ValidBefore" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conditions" msprop:Generator_ColumnVarNameInTable="columnConditions" msprop:Generator_ColumnPropNameInRow="Conditions" msprop:Generator_ColumnPropNameInTable="ConditionsColumn" msprop:Generator_UserColumnName="Conditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Protein" msprop:Generator_ColumnVarNameInTable="columnProtein" msprop:Generator_ColumnPropNameInRow="Protein" msprop:Generator_ColumnPropNameInTable="ProteinColumn" msprop:Generator_UserColumnName="Protein" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fat" msprop:Generator_ColumnVarNameInTable="columnFat" msprop:Generator_ColumnPropNameInRow="Fat" msprop:Generator_ColumnPropNameInTable="FatColumn" msprop:Generator_UserColumnName="Fat" type="xs:decimal" minOccurs="0" />
              <xs:element name="Carbonhydrates" msprop:Generator_ColumnVarNameInTable="columnCarbonhydrates" msprop:Generator_ColumnPropNameInRow="Carbonhydrates" msprop:Generator_ColumnPropNameInTable="CarbonhydratesColumn" msprop:Generator_UserColumnName="Carbonhydrates" type="xs:decimal" minOccurs="0" />
              <xs:element name="EnergyValue" msprop:Generator_ColumnVarNameInTable="columnEnergyValue" msprop:Generator_ColumnPropNameInRow="EnergyValue" msprop:Generator_ColumnPropNameInTable="EnergyValueColumn" msprop:Generator_UserColumnName="EnergyValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareCategory" msprop:Generator_ColumnVarNameInTable="columnWareCategory" msprop:Generator_ColumnPropNameInRow="WareCategory" msprop:Generator_ColumnPropNameInTable="WareCategoryColumn" msprop:Generator_UserColumnName="WareCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="DateUpdatePrice" msprop:Generator_ColumnVarNameInTable="columnDateUpdatePrice" msprop:Generator_ColumnPropNameInRow="DateUpdatePrice" msprop:Generator_ColumnPropNameInTable="DateUpdatePriceColumn" msprop:Generator_UserColumnName="DateUpdatePrice" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Counter" msprop:Generator_ColumnVarNameInTable="columnCounter" msprop:Generator_ColumnPropNameInRow="Counter" msprop:Generator_ColumnPropNameInTable="CounterColumn" msprop:Generator_UserColumnName="Counter" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" />
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" minOccurs="0" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LiveID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLiveID" msprop:Generator_ColumnPropNameInRow="LiveID" msprop:Generator_ColumnPropNameInTable="LiveIDColumn" msprop:Generator_UserColumnName="LiveID" type="xs:string" minOccurs="0" />
              <xs:element name="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsHidden" msprop:Generator_ColumnVarNameInTable="columnIsHidden" msprop:Generator_ColumnPropNameInRow="IsHidden" msprop:Generator_ColumnPropNameInTable="IsHiddenColumn" msprop:Generator_UserColumnName="IsHidden" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SET_GroupID" msprop:Generator_TableClassName="SET_GroupIDDataTable" msprop:Generator_TableVarName="tableSET_GroupID" msprop:Generator_TablePropName="SET_GroupID" msprop:Generator_RowDeletingName="SET_GroupIDRowDeleting" msprop:Generator_UserTableName="SET_GroupID" msprop:Generator_RowChangingName="SET_GroupIDRowChanging" msprop:Generator_RowEvHandlerName="SET_GroupIDRowChangeEventHandler" msprop:Generator_RowDeletedName="SET_GroupIDRowDeleted" msprop:Generator_RowEvArgName="SET_GroupIDRowChangeEvent" msprop:Generator_RowChangedName="SET_GroupIDRowChanged" msprop:Generator_RowClassName="SET_GroupIDRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="ADD_Ware" msprop:Generator_TableClassName="ADD_WareDataTable" msprop:Generator_TableVarName="tableADD_Ware" msprop:Generator_TablePropName="ADD_Ware" msprop:Generator_RowDeletingName="ADD_WareRowDeleting" msprop:Generator_UserTableName="ADD_Ware" msprop:Generator_RowChangingName="ADD_WareRowChanging" msprop:Generator_RowEvHandlerName="ADD_WareRowChangeEventHandler" msprop:Generator_RowDeletedName="ADD_WareRowDeleted" msprop:Generator_RowEvArgName="ADD_WareRowChangeEvent" msprop:Generator_RowChangedName="ADD_WareRowChanged" msprop:Generator_RowClassName="ADD_WareRow">
          <xs:complexType>
          </xs:complexType>
        </xs:element>
        <xs:element name="GET_WaresWithFilters" msprop:Generator_TableClassName="GET_WaresWithFiltersDataTable" msprop:Generator_TableVarName="tableGET_WaresWithFilters" msprop:Generator_TablePropName="GET_WaresWithFilters" msprop:Generator_RowDeletingName="GET_WaresWithFiltersRowDeleting" msprop:Generator_UserTableName="GET_WaresWithFilters" msprop:Generator_RowChangingName="GET_WaresWithFiltersRowChanging" msprop:Generator_RowEvHandlerName="GET_WaresWithFiltersRowChangeEventHandler" msprop:Generator_RowDeletedName="GET_WaresWithFiltersRowDeleted" msprop:Generator_RowEvArgName="GET_WaresWithFiltersRowChangeEvent" msprop:Generator_RowChangedName="GET_WaresWithFiltersRowChanged" msprop:Generator_RowClassName="GET_WaresWithFiltersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WaresID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnWaresID" msprop:Generator_ColumnPropNameInRow="WaresID" msprop:Generator_ColumnPropNameInTable="WaresIDColumn" msprop:Generator_UserColumnName="WaresID" type="xs:string" />
              <xs:element name="WareName" msprop:Generator_ColumnVarNameInTable="columnWareName" msprop:Generator_ColumnPropNameInRow="WareName" msprop:Generator_ColumnPropNameInTable="WareNameColumn" msprop:Generator_UserColumnName="WareName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDesc" msprop:Generator_ColumnVarNameInTable="columnShortDesc" msprop:Generator_ColumnPropNameInRow="ShortDesc" msprop:Generator_ColumnPropNameInTable="ShortDescColumn" msprop:Generator_UserColumnName="ShortDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDesc" msprop:Generator_ColumnVarNameInTable="columnFullDesc" msprop:Generator_ColumnPropNameInRow="FullDesc" msprop:Generator_ColumnPropNameInTable="FullDescColumn" msprop:Generator_UserColumnName="FullDesc">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SHCode" msprop:Generator_ColumnVarNameInTable="columnSHCode" msprop:Generator_ColumnPropNameInRow="SHCode" msprop:Generator_ColumnPropNameInTable="SHCodeColumn" msprop:Generator_UserColumnName="SHCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceMain" msprop:Generator_ColumnVarNameInTable="columnPriceMain" msprop:Generator_ColumnPropNameInRow="PriceMain" msprop:Generator_ColumnPropNameInTable="PriceMainColumn" msprop:Generator_UserColumnName="PriceMain" type="xs:decimal" />
              <xs:element name="PriceRed" msprop:Generator_ColumnVarNameInTable="columnPriceRed" msprop:Generator_ColumnPropNameInRow="PriceRed" msprop:Generator_ColumnPropNameInTable="PriceRedColumn" msprop:Generator_UserColumnName="PriceRed" type="xs:decimal" minOccurs="0" />
              <xs:element name="GroupID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGroupID" msprop:Generator_ColumnPropNameInRow="GroupID" msprop:Generator_ColumnPropNameInTable="GroupIDColumn" msprop:Generator_UserColumnName="GroupID" type="xs:string" minOccurs="0" />
              <xs:element name="NettoWeight" msprop:Generator_ColumnVarNameInTable="columnNettoWeight" msprop:Generator_ColumnPropNameInRow="NettoWeight" msprop:Generator_ColumnPropNameInTable="NettoWeightColumn" msprop:Generator_UserColumnName="NettoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="BruttoWeight" msprop:Generator_ColumnVarNameInTable="columnBruttoWeight" msprop:Generator_ColumnPropNameInRow="BruttoWeight" msprop:Generator_ColumnPropNameInTable="BruttoWeightColumn" msprop:Generator_UserColumnName="BruttoWeight" type="xs:decimal" minOccurs="0" />
              <xs:element name="Recipe" msprop:Generator_ColumnVarNameInTable="columnRecipe" msprop:Generator_ColumnPropNameInRow="Recipe" msprop:Generator_ColumnPropNameInTable="RecipeColumn" msprop:Generator_UserColumnName="Recipe" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PriceCategory" msprop:Generator_ColumnVarNameInTable="columnPriceCategory" msprop:Generator_ColumnPropNameInRow="PriceCategory" msprop:Generator_ColumnPropNameInTable="PriceCategoryColumn" msprop:Generator_UserColumnName="PriceCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Staff" msprop:Generator_ColumnVarNameInTable="columnStaff" msprop:Generator_ColumnPropNameInRow="Staff" msprop:Generator_ColumnPropNameInTable="StaffColumn" msprop:Generator_UserColumnName="Staff" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StaffListGuid" msprop:Generator_ColumnVarNameInTable="columnStaffListGuid" msprop:Generator_ColumnPropNameInRow="StaffListGuid" msprop:Generator_ColumnPropNameInTable="StaffListGuidColumn" msprop:Generator_UserColumnName="StaffListGuid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidBefore" msprop:Generator_ColumnVarNameInTable="columnValidBefore" msprop:Generator_ColumnPropNameInRow="ValidBefore" msprop:Generator_ColumnPropNameInTable="ValidBeforeColumn" msprop:Generator_UserColumnName="ValidBefore" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Conditions" msprop:Generator_ColumnVarNameInTable="columnConditions" msprop:Generator_ColumnPropNameInRow="Conditions" msprop:Generator_ColumnPropNameInTable="ConditionsColumn" msprop:Generator_UserColumnName="Conditions" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Protein" msprop:Generator_ColumnVarNameInTable="columnProtein" msprop:Generator_ColumnPropNameInRow="Protein" msprop:Generator_ColumnPropNameInTable="ProteinColumn" msprop:Generator_UserColumnName="Protein" type="xs:decimal" minOccurs="0" />
              <xs:element name="Fat" msprop:Generator_ColumnVarNameInTable="columnFat" msprop:Generator_ColumnPropNameInRow="Fat" msprop:Generator_ColumnPropNameInTable="FatColumn" msprop:Generator_UserColumnName="Fat" type="xs:decimal" minOccurs="0" />
              <xs:element name="Carbonhydrates" msprop:Generator_ColumnVarNameInTable="columnCarbonhydrates" msprop:Generator_ColumnPropNameInRow="Carbonhydrates" msprop:Generator_ColumnPropNameInTable="CarbonhydratesColumn" msprop:Generator_UserColumnName="Carbonhydrates" type="xs:decimal" minOccurs="0" />
              <xs:element name="EnergyValue" msprop:Generator_ColumnVarNameInTable="columnEnergyValue" msprop:Generator_ColumnPropNameInRow="EnergyValue" msprop:Generator_ColumnPropNameInTable="EnergyValueColumn" msprop:Generator_UserColumnName="EnergyValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnPropNameInTable="CountryColumn" msprop:Generator_UserColumnName="Country">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WareCategory" msprop:Generator_ColumnVarNameInTable="columnWareCategory" msprop:Generator_ColumnPropNameInRow="WareCategory" msprop:Generator_ColumnPropNameInTable="WareCategoryColumn" msprop:Generator_UserColumnName="WareCategory">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LightValue" msprop:Generator_ColumnVarNameInTable="columnLightValue" msprop:Generator_ColumnPropNameInRow="LightValue" msprop:Generator_ColumnPropNameInTable="LightValueColumn" msprop:Generator_UserColumnName="LightValue" type="xs:decimal" minOccurs="0" />
              <xs:element name="DateUpdatePrice" msprop:Generator_ColumnVarNameInTable="columnDateUpdatePrice" msprop:Generator_ColumnPropNameInRow="DateUpdatePrice" msprop:Generator_ColumnPropNameInTable="DateUpdatePriceColumn" msprop:Generator_UserColumnName="DateUpdatePrice" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Counter" msprop:Generator_ColumnVarNameInTable="columnCounter" msprop:Generator_ColumnPropNameInRow="Counter" msprop:Generator_ColumnPropNameInTable="CounterColumn" msprop:Generator_UserColumnName="Counter" type="xs:int" />
              <xs:element name="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" msprop:Generator_UserColumnName="Rating" type="xs:int" />
              <xs:element name="ShopID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnShopID" msprop:Generator_ColumnPropNameInRow="ShopID" msprop:Generator_ColumnPropNameInTable="ShopIDColumn" msprop:Generator_UserColumnName="ShopID" type="xs:string" minOccurs="0" />
              <xs:element name="Shop" msprop:Generator_ColumnVarNameInTable="columnShop" msprop:Generator_ColumnPropNameInRow="Shop" msprop:Generator_ColumnPropNameInTable="ShopColumn" msprop:Generator_UserColumnName="Shop" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LiveID" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnLiveID" msprop:Generator_ColumnPropNameInRow="LiveID" msprop:Generator_ColumnPropNameInTable="LiveIDColumn" msprop:Generator_UserColumnName="LiveID" type="xs:string" minOccurs="0" />
              <xs:element name="Article" msprop:Generator_ColumnVarNameInTable="columnArticle" msprop:Generator_ColumnPropNameInRow="Article" msprop:Generator_ColumnPropNameInTable="ArticleColumn" msprop:Generator_UserColumnName="Article" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsPiece" msprop:Generator_ColumnVarNameInTable="columnIsPiece" msprop:Generator_ColumnPropNameInRow="IsPiece" msprop:Generator_ColumnPropNameInTable="IsPieceColumn" msprop:Generator_UserColumnName="IsPiece" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsHidden" msprop:Generator_ColumnVarNameInTable="columnIsHidden" msprop:Generator_ColumnPropNameInRow="IsHidden" msprop:Generator_ColumnPropNameInTable="IsHiddenColumn" msprop:Generator_UserColumnName="IsHidden" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsDeleted" msprop:Generator_ColumnVarNameInTable="columnIsDeleted" msprop:Generator_ColumnPropNameInRow="IsDeleted" msprop:Generator_ColumnPropNameInTable="IsDeletedColumn" msprop:Generator_UserColumnName="IsDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_Shops" />
      <xs:field xpath="mstns:ShopID" />
    </xs:unique>
    <xs:unique name="GET_Ingredients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_Ingredients" />
      <xs:field xpath="mstns:IngredientID" />
    </xs:unique>
    <xs:unique name="GET_IngredientTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_IngredientTypes" />
      <xs:field xpath="mstns:IngredientTypeID" />
    </xs:unique>
    <xs:unique name="GET_WareActions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_WareActions" />
      <xs:field xpath="mstns:ActionID" />
    </xs:unique>
    <xs:unique name="GET_WareActionsByManager_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_WareActionsByManager" />
      <xs:field xpath="mstns:ActionID" />
    </xs:unique>
    <xs:unique name="GET_AllWareActions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_AllWareActions" />
      <xs:field xpath="mstns:ActionID" />
    </xs:unique>
    <xs:unique name="GET_StaffList_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:GET_StaffList" />
      <xs:field xpath="mstns:IngridientID" />
    </xs:unique>
    <xs:unique name="GET_CheckList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_CheckList" />
      <xs:field xpath="mstns:CheckID" />
    </xs:unique>
    <xs:unique name="GET_ClientCheckLists_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_ClientCheckLists" />
      <xs:field xpath="mstns:CheckListID" />
    </xs:unique>
    <xs:unique name="GET_WaresForChanges_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_WaresForChanges" />
      <xs:field xpath="mstns:MarkID" />
    </xs:unique>
    <xs:unique name="GET_ImportCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GET_ImportCategory" />
      <xs:field xpath="mstns:CategoryID" />
    </xs:unique>
  </xs:element>
</xs:schema>